Too hasty with the first post.

If your list of items is in a range of say, A2:A800, simply enter Bernie's
formula in B2 then copy down to B800 by double-click on the fill handle of
B2.


Gord

On Tue, 19 Aug 2008 12:15:01 -0700, vburns
wrote:

Does this mean I still have to type in the item number each time in cell A2
to return the price from the other worksheet?

"Bernie Deitrick" wrote:

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?