Index / Match Functions

[KishorKK]

Hi Friends,

Please help me with index / match formula, can some one tell me where am i going wrong in this???

 

[KishorKK]

can we use vlook up for it? how

 

[PCosta87]

Hi,

It should be
=INDEX($E$2:$E$6,MATCH($B11,$B$2:$B$6,0))

With VLOOKUP it should be

=VLOOKUP($B11,$B$2:$E$6,4,FALSE)

 

[Deepak]

=INDEX($A$2:$E$6,MATCH($B11,$B$2:$B$6,0),4)

When u skip the third argument in index fn then it only take care for data in first column of injected range.

=vlookup(b11,$A$2:$E$6,4,0)

For more info more on dynamic index+match check the attached.

 

[Gireesh]

Hi Kishore,

suggestion:

1. If you want to look up a value from left to right, use VLOOKUP.
Ex: Your scenario
2. look up a value from right to left use, combination of INDEX and MATCH function.

 

[Khalid NGO]

Hi to all,

One more with simple SUMIF:

=SUMIF($B$2:$B$6,B11,$E$2:$E$6)

Regards,

 

[KishorKK]

thank u all