Let's say that your common item numbers are both in column A

=VLOOKUP(A2,OtherSheet!A:H,8,False)

will pull the data from column H of the OtherSheet. If you actually have a separate workbook, then
the formula will be slightly different, but not significantly.

HTH,
Bernie
MS Excel MVP


"vburns" wrote in message
...
I have a list of 800 items I must look up from one worksheet and enter the
price on another worksheet. The worksheets are not similar. Using a common
item number that appears in both worksheets, will VLOOKUP do this for me? In
other words copy a price from one worksheet to the proper column in another
worksheet?