Hi,

I'm new on this forum, as with many of you guys i assume, a frustrating problem got me to sign up.

Basically I'm trying to get vlookup to work and get information from another worksheet I have in the same excel file. (see shipping rates by supplier worksheet for vlookup formula in supplier column)

=VLOOKUP(B4,'Product Nomenclature'!B:Y,6,FALSE)

The vlookup function will only return values when it is = true, which is not what i want since I am looking for exact values, when using false, I get N/A back as an answer.

I've tried, trim and value functions as well as formatting related causes which hasn't helped me thus far.

I've included my excel sheet hoping that perhaps one of you will be able to help me!

Thanks

Selling-price-worksheet_2013-03-04(2).xlsx