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.

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.

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