VLOOKUP not finding EXACT match???

Mahatma · Mar 30th, 2004, 02:44 AM

I have a column of numbers that I'm usuing a VLOOKUP on to retrieve the data from another tab in the same spreadsheet. The VLOOKUP is bringing back the data for next closest number but not the exact number.

Ex: I am searching for 01041, the VLOOKUP brought back the data for 01040 because 01041 wasn't in my array and 1040 iss the closest number it found. How do I make it return the data only if it's an exact match?

I have a project due in the AM and I'm stressing over this problem, your help is appreciated.

PaddyD · Mar 30th, 2004, 02:45 AM

set the last parameter to FALSE or 0 (which are equivalent). fwiw, it's usually best to post up the formula you're using when you've got a question about it...

Brian from Maui · Mar 30th, 2004, 03:09 AM

In addition to Paddy's solution, you may want to look at this thread. If there is no exact match, VLOOKUP will return #N/A.

http://216.92.17.166/board2/viewtopic.php?t=62102

Mar 30th, 2004, 02:44 AM	#1
Mahatma Join Date: May 2003 Location: Deep in the heart of Texas! Posts: 33	VLOOKUP not finding EXACT match??? I have a column of numbers that I'm usuing a VLOOKUP on to retrieve the data from another tab in the same spreadsheet. The VLOOKUP is bringing back the data for next closest number but not the exact number. Ex: I am searching for 01041, the VLOOKUP brought back the data for 01040 because 01041 wasn't in my array and 1040 iss the closest number it found. How do I make it return the data only if it's an exact match? I have a project due in the AM and I'm stressing over this problem, your help is appreciated.

Mar 30th, 2004, 03:09 AM	#3
Brian from Maui Join Date: Feb 2002 Posts: 7,605	Re: VLOOKUP not finding EXACT match??? In addition to Paddy's solution, you may want to look at this thread. If there is no exact match, VLOOKUP will return #N/A. http://216.92.17.166/board2/viewtopic.php?t=62102

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

Mar 30th, 2004, 02:45 AM	#2
PaddyD MrExcel MVP Join Date: May 2002 Posts: 12,561	set the last parameter to FALSE or 0 (which are equivalent). fwiw, it's usually best to post up the formula you're using when you've got a question about it...