VLOOKUP problem
 

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

VLOOKUP problem
 

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

VLOOKUP problem
 

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

"DaveO" wrote:

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