Not able to put Vlookup function

[webmax]

Hi

I have a attached data in which i not able to put the vlookup function because my base data (Lookup Value )is after the output field which i required.

Kindly go through the attached file and guide me the formula

 

[Shteven]

Using an INDEX MATCH formula will get you the same result as as a VLOOKUP formula, but INDEX MATCH has the added benefit of allowing you to go right-to-left!

It's easy to convert your VLOOKUP to INDEX MATCH:

=VLOOKUP(Value,BegColumn:EndColumn,ColumnNum,True/False)
... now becomes ...
=INDEX(EndColumn,MATCH(Value,BegColumn,True/False))

Use this in your spreadsheet:
=INDEX($A:$A,MATCH($H6,$C:$C,0))

 

[NARAYANK991]

Hi ,

Another option ; you can change the order of the headers in I5 and J5.

Narayan

 

[Atlas Johnson]

Another option can be to use SUMIF() like;

=SUMIF($C$2:$C$16,$H6,A$2:A$16)

Cheers,
AJ