Vlookup and IF
 

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 and IF
 

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 and IF
 

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

Vlookup and IF
 

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!

Vlookup and IF
 

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!