matching & combining data from seperate worksheets

  • Thread starter Thread starter sshaefer
  • Start date Start date
S

sshaefer

Hi, I am working on a data import and need to get the opportunity name from
one data source into the appropriate row to matching shipments from another
data source, I have two matching fields in each database. customer id and
part number..

I need to search 2 columns of data by row on two seperate worksheets and
return a seperate column if they match.

Ex:
Worksheet A: Shipment Data, Column C (customer id) & column F (Item Id)
Worksheet B: Opportunity Data, Column A (customer id) & column B (Part Number)

on worksheet A Column E, I need a formula that will search column C on
current worksheet and compare it to column A from worksheet B, if a customer
id matches, I need it to compare the item id's from the same row, if both the
customer id and item/part # match on a row, then I need it to return the
opportunity name (column C from Worksheet B) to the row that contains the
matching cust. Id and part numb on worksheet A .

is this even possible?

Thanks
 
Sounds like a sumproduct formula will work for you.
=sumproduct((a2:a22="name")*(b2:b22=number)*c2:c22)
 
Back
Top