Need formula to lookup or sum based on criteria

[Syedali]

Hi frds,

Any ideas kindly help on this.

Please find attached document, i have explained.

 

[bosco_yip]

Try,

In E8, copied down :

=INDEX($G$3:$K$5,MATCH(C8,$F$3:$F$5,0),MATCH(SMALL($G$2:$K$2,COUNTIF($G$2:$K$2,"<="&B8)),$G$2:$K$2,0))

Regards
Bosco

 

[John Jairo V]

Hi, to both!

Another option could be:
[E8] : =VLOOKUP(C8,F$3:K$5,MATCH(B8,F$2:K$2),)

Blessings!

 

[Peter Bartholomew]

The main difference is that I have placed the formula within a table
= INDEX( rate, MATCH([@Destination],destination,0), MATCH([@Date],date) )

It looks a bit long-winded but I never use references that depend upon location within the sheet, i.e. no direct cell references.

 

[Syedali]

Super, Without exact match....!!!!

 

[Syedali]

Thanks to everyone...........