Vlookup returning incorrect result?

**Delarado** · 08-19-2009, 06:36 AM

Guys,

I have an issue whereby vlookup is returning incorrect data.

I have a named data range on worksheet "prices" that is called from a drop down box on another worksheet, so you get a drop down list with all of the item names.

Next to the item names on the first page is the price of that particular item.

Next to the drop down box on the second worksheet is a vlookup that looks at the value of the drop down box, and takes the value in column 2 of the afordmentioned sheet.

The vlookup returns the wrong value in some cases. My understanding is that with:

=VLOOKUP(A37,Prices!H14:I53,2)

Excel SHOULD look at whats in A37. It then looks on the Prices worksheet in cells H14:I53. When it finds what it found in A37 within that range, it returns the data in column I (column 2) that is next to the matched item.

However, if you look at the spreadsheet, try selecting "tungsten carbide Armor" and youll see its actually returning the price for "Titanium Diborate Armor" if you refer to the "prices" worksheet.

What is going on, can anyone help? Theres quite a few doing this!

Spreadsheet attached, apologies if its agianst the rules. Theres nothing important or sensitive in there.

**DonkeyOte** · 08-19-2009, 06:39 AM

See XL Help re: optional final parameter of Range_Lookup, you need:

=VLOOKUP(A37,Prices!H14:I53,2,FALSE)

**Delarado** · 08-19-2009, 06:40 AM

Apologies, the two worksheets relevant are "prices" and "ballistic"

Cell concerned is A37 for the drop down and B37 for the vlookup on the "ballistic" worksheet. On the Prices worksheet, CTRL+F3 it to see the range the drop down looks at (components)

Any other questions let me know. Plan is to make a working formula in B37 and replicate it for the rest.