Vlookup pulling wrong value

[AR10080]

I have following table that I am using to VLOOKUP.
My lookup formula is

=VLOOKUP("40-7",TableName,3)

Unfortunately, the output value is 43-0791 which is for "40-6.5"!
No idea what I am doing wrong!

WEIGHT	DESCRIPTION	PART NO
40-6.5	HINGE TUBE, (1" SCH 80 X 2")	43-0791
45-6.5	HINGE TUBE, (1.5" OD X 2")	43-1540
40-7	HINGE TUBE, (1" SCH 80 X 4-1/2")	43-0790
45-7	HINGE TUBE, (1.5" OD X 4-1/2")	43-1539

 

[dreid1011]

Try it with FALSE at the end:

=VLOOKUP("40-7",TableName,3,FALSE)

 

[AR10080]

Try it with FALSE at the end:

=VLOOKUP("40-7",TableName,3,FALSE)

View attachment 103618

Ohh yah. I missed it! Thank you very much.

 

[dreid1011]

You're welcome, happy to help.