VLOOKUP shows #N/A

[trader10518]

I can't get why..

 

[jasonb75]

Most likely because the criteria is not found in column A. With vlookup, the criteria must be in the left hand column, for anything else you need index and match

=INDEX($A$1:$A$1404,MATCH(E1,$C$1:$C$1404,FALSE))

 

[trader10518]

Most likely because the criteria is not found in column A. With vlookup, the criteria must be in the left hand column, for anything else you need index and match

=INDEX($A$1:$A$1404,MATCH(E1,$C$1:$C$1404,FALSE))

Jason, thanks a lot, much appreciate your help!