Forum Discussion
Complex Text Formula?
I tried the fuzzy matching through power query but I don't think that it is producing the desired output considering the data in your data table and the data in your Specialty list on sheet.
Look at the column D with a Vlookup formula which you can copy and paste as Values in column E if you are satisfied with the output returned by the formula and then delete the column D.
Thank you sir. I have scrubbed this one of sensitive data. There is another column next to F that also contains more data, but I cannot share that column for privacy issues.
If I am able to get this medical specialties column, I can then create a pivot table showing whether more patients are seeing doctors in certain specialties throughout a period of time.
I tried the fuzzy matching through power query but I don't think that it is producing the desired output considering the data in your data table and the data in your Specialty list on sheet.
Look at the column D with a Vlookup formula which you can copy and paste as Values in column E if you are satisfied with the output returned by the formula and then delete the column D.