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!

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!

=VLOOKUP(A1,Sheet2!A1:B100,2,False)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"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!

That's pretty much what this tutorial teaches you:
http://www.officearticles.com/tutori...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"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!

Thanks, but I did try that first. Sorry to bother you.

"Don Guillett" wrote:

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!