Hi,
I am trying to capture a partial text string from an Excel match.
RawData tab = data source
Calc tab = Where I am calculating the data. I am doing a vlookup with a match to find the specific cell but all I want to pull is Low, Medium, High text strings. Whereas today, each rating has a prefix text string. See column E for the desired outcome I am trying to achieve.
Any help is greatly appreciated.
Thank you
Bookmarks