Attached is an excel file with 3 tabs:
1) The master tab
2) The primary tab
3) The secondary tab
I need an excel expert to build an IF calculation on the master tab.
The two fields that your attention are: MARKETING_SOURCE and MARKETING_SOURCE_DTL.
Here is what I need to be able to do: I need to be able to paste large amounts of data on the master tab and the calculation - that you design - will look at the primary and secondary tab to find the missing values for MARKETING_SOURCE and MARKETING_SOURCE_DTL.
I color coded the attached excel sheet to help explain the project, so please download it to get a better understanding.
The colors represent the tabs and fields that.
Please note that your calculation needs to be able to scale, meaning in the future I want to add fields and values to the primary and secondary tab --- so the master tab, which has your calculation on the MARKETING_SOURCE and MARKETING_SOURCE_DTL fields --- needs to allow me a way to accomplish this.