You can use VLOOKUP to do this. Check it out in Help, or re-post here
with a few more details of what you want to do.

Hope this helps.

Pete

Pennywis1 wrote:

I would like to enter an item number in column A of the destination workbook,
yet have additional information pertaining to that item number pull from a
source workbook to the destination workbook. Any idea how I can do this?