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?

"Seeking help" wrote:


Hey peeps,

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


--
Seeking help
------------------------------------------------------------------------
Seeking help's Profile: http://www.excelforum.com/member.php...o&userid=35658
View this thread: http://www.excelforum.com/showthread...hreadid=569331