Forum Discussion
Matching Data from two Sources, with INDEX/MATCH and/or Lookups
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 ...
In G5:
="EWP"&LEFT(MID(F5,FIND("-",F5),100),LEN(MID(F5,FIND("-",F5),100))-1)
Fill down.