Thread: Vlookup and IF
View Single Post
  #1   Report Post  
Nancy B
 
Posts: n/a
Default 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!