CODEWITHSUNDEEP
excel
kannan m
kannan m

Reputation: 67

Vlookup in excel returns NA

I have an excel with 3 columns populated.

The scenario is I want to compare values from column J with H and return the result value from F. I wrote the VLOOKUP but its not returning the values.

Below pasted are the screenshots of this scenario:

VLOOKUP Formula used = =VLOOKUP(J1,$F:$H,1,FALSE)

enter image description here

Is there something wrong with the formula or is there any other way to do it?

Upvotes: 0

Views: 67

Answers (2)

Tim Wilkinson
Tim Wilkinson

Reputation: 3791

Using index match

=INDEX($F:$F, MATCH($J1,$H:$H, 0))

You can't look 'backwards' with VLOOKUP, and whilst it has its bonuses for situations like this always use INDEX MATCH

Upvotes: 1

PSotor
PSotor

Reputation: 346

You could try this =INDIRECT("F" & MATCH(J1,$H:$H,0)).

Upvotes: 0

Related Questions