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?