If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
matching & combining data from seperate worksheets
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 |
#2
|
|||
|
|||
matching & combining data from seperate worksheets
|
Thread Tools | |
Display Modes | |
|
|