VLOOKUP Question for New User

[vburns]

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?

 

[Bernie Deitrick]

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]

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?

 

[Gord Dibben]

Yes

Perhaps a Data Validation Dropdown list in A2 would help?

See Debra Dalgleish's site for help on Data Validation lists.

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP