VLOOKUP error

[SPIG]

Hello all,
Im having an issue with a VLOOKUP error i keep getting. This is what im using and im sure its right =VLOOKUP(A1,Sheet1!$A$1:$L$72,2,FALSE) unless other wise. the data im using is a pretty big sheet so i chopped it down for easier view.

I dont care what kind of value it returns, as long as it it something. It will help me sort the sheet and get rid of the item codes that are not being used anymore...there are thousands to sort through.

On the first sheet is the item code in column A and the short description in B.. on the second sheet is the actual products that are carried now.And you can see them on "sheet1" B61 and B57 so you dont think im crazy...Any help correcting my error is greatly appreciated

Thanks
See attachedtest.xlsx

[sktneer]

Lookup value should always be in the first column of Table_Array used in Vlookup function.

Try this.....

Please Login or Register  to view this content.

[SPIG]

Well that makes more sense. Thanks sktneer

[sktneer]

You're welcome.