Have a look in help index for VLOOKUP

--
Don Guillett
SalesAid Software

"Nancy B" wrote in message
...
I'm looking for help with the following scenario:

Worksheet A contains a list of item numbers; worksheet B contains the same
list of item numbers with another column containing a cost for the item.
I
want Excel to look up each item number on worksheet A, find the same item
number on worksheet B, then take the cost for the item and populate it
onto
worksheet A.

Thanks!