My spreadsheet contains 6 columns, with data beginning in cell A3. The first row of records A3 thru C1751 contains the following:
Bank # Customer Acct. # Customer's FICO
This data is for Set 1
The next three columns represent Set 2 and are headed the same as the first three columns, beginning with Cell D3 and ending with Cell F738
Cells are populated for each of the 3 columns in Set 1
The Column labled "Customer's FICO" is blank for Set 2
Many of the account numbers and corresponding "Customer's FICO" values will match records found is Set 2. What I need to do is create a table or formula that will go through all the data, finding similar account numbers from Set 1 (Columns A B C) and match them up with the values in columns D and E. Since the FICO value doesn't change from Set 1 to Set 2, the "program" should be able to just match the data on account number and bank # and the FICO value should come over too.
Start Free Trial
