No, sorry that didn't work either.

I am almost convinced (because i have done vlookups on tons of worksheets I
produced) that there is something wrong with the data (part numbers). Is
there any way to ensure that the two sheets have exactly the correct matching
format? (I presently have paint formatted all to text).

thanks,
mk

xlm wrote:
try this

=VLOOKUP(A2,Sheet2!C:I,7,0)

A2 is the value you want to look up, this is in Sheet1
Sheet2!C:I is your table,
make sure that you have a sheet named "Cdn" exactly and that your column
number
is correct at 6 where you want the value to return.
In the above, I am using 7 as I found col I is column no 7

Does it works for you?

HTH

Pls click the Yes button below if this is helpful

cheers, francis

Thankx for your reply. I have two sheets in one workbook. I want to take
one or the other of them and bring over the matching price for each part that
[quoted text clipped - 13 lines]
any suggestions?
thanks

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200812/1