VLOOKUP problem

S

Seeking help

Hey peeps,

Do you have any idea what is wrong with this formul
"=VLOOKUP(A2,'Supplier list'!$A$2:$M$9710,2,FALSE)"? The value it i
extracting with is not blank but is a text
 
D

DaveO

Could this simply be an issue with a text value having a space at the end in
cell A2?

If not can you see the value in A2 in the list you;re looking up?
 
V

Varun

I suggest you should try the "trim" function on your lookup value and then
use vlookup. there might be some blank spaces at d beginninng or end of text
because of which you are not getting wht you want.

Regards
 
Top