see attached excel file - $15 bonus if completed in the next? 4 hours
In essence, we need the solution to look at an account number on the tabs Moderate, Moderate 7, Moderate 5, Moderate 3, Moderate 2,? and Moderate 1 and find the same last 4 digits in column A of the "Master" tab along the bottom.? Once it finds the corresponding acct number on Master is needs to copy the field next to it in column b to column A on the corresponding Moderate spreadsheet.
?
Let me use an example:
In the Moderate tab, block B5 reads "1147"
This corresponds to block A19 on Master reads "9171147"
Subsequently we need some magic to pull block B19, which reads 952939293 and paste that into block A5 on the Moderate tab.
?
now repeat the process for all of the account numbers on all the tabs, starting next wtih block B6 on the Moderate tab.
## Deliverables
NA