Vlookup

MattB · Apr 4th, 2002, 06:45 AM

Hi all

I seem to have an incredibly frustrating problem with VLookups. I rely on it as I need to analyse thousands of part codes, yet I just don't seem to be able to trust it.
I have taken a sample from the 2 s/sheets concerned where I'm attempting to look up a cost for a part code when the code exists in the other s/s. It returns a #n/a to me when it's blatantly obvious that the code does exist. I suspect some sort of formatting difference but I can't seem to find it myself.
Could anybody take a look or does anybody know what it could be??
Thanks

Matt

Anne Troy · Apr 4th, 2002, 06:47 AM

Matt:

Check out the *Dreaded* Vlookup at:

http://www.thewordexpert.com/tipwarez.htm#MyVlookup

It probably explains your problem too.

Mark W. · Apr 4th, 2002, 07:45 AM

Matt, the data type matters!!!

"17863" <> 17863

MattB · Apr 4th, 2002, 08:09 AM

Mark

Couldn't be a little more specific could you!?

Ricky Morris · Apr 4th, 2002, 08:13 AM

there might be spaces after the numbers and/or letters in your source and not in your destination, or vice versa that might not be visible. Use the trim function to remove these space if they exist.

Apr 4th, 2002, 06:47 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Matt: Check out the Dreaded Vlookup at: http://www.thewordexpert.com/tipwarez.htm#MyVlookup It probably explains your problem too. __________________ ~Anne Troy

Apr 4th, 2002, 08:13 AM	#5
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	there might be spaces after the numbers and/or letters in your source and not in your destination, or vice versa that might not be visible. Use the trim function to remove these space if they exist. __________________ It's never too late to learn something new. Ricky

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 4th, 2002, 06:45 AM	#1
MattB Board Regular Join Date: Mar 2002 Posts: 62	Hi all I seem to have an incredibly frustrating problem with VLookups. I rely on it as I need to analyse thousands of part codes, yet I just don't seem to be able to trust it. I have taken a sample from the 2 s/sheets concerned where I'm attempting to look up a cost for a part code when the code exists in the other s/s. It returns a #n/a to me when it's blatantly obvious that the code does exist. I suspect some sort of formatting difference but I can't seem to find it myself. Could anybody take a look or does anybody know what it could be?? Thanks Matt

Apr 4th, 2002, 07:45 AM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Matt, the data type matters!!! "17863" <> 17863

Apr 4th, 2002, 08:09 AM	#4
MattB Board Regular Join Date: Mar 2002 Posts: 62	Mark Couldn't be a little more specific could you!?