Hi all
I am trying to find a formula to find closest match on a text string using index match preferably and vlookup true so the data does not need to be altered.
I know the formula using index match to match closest amounts is =INDEX($H$2:$K$60,MATCH(A2&C2,$H$2:$H$60&$J$2:$J$61,0),1) entered as an array.
What would be the equivalent to look up closest text match?
I've attached a worksheet were I would be trying to lookup the vehicle type on sheet one column D to closest match on sheet two column E.
Appreciate any help.
Bookmarks