Dec 19 2020 07:54 AM
I have two sources of data from two providers. Since they are similar, I would like to combine the two sources through formulas in-lieu of manually entering and adjusting the data. Can the Microsoft Community Help please provide different examples on how to approach this? Index, Match, Lookups, Aggregrate, etc.
Thank you all!
See attached Spreadsheet on what I want to achieve.
Dec 19 2020 08:46 AM
In G5:
="EWP"&LEFT(MID(F5,FIND("-",F5),100),LEN(MID(F5,FIND("-",F5),100))-1)
Fill down.