C ccarruth Member May 9, 2016 #1 Hey guys- Looking to extract a value within a delimited string, based on value found in another cell in conjunction with hlookup table. Workbook should be clear.. Attachments Chandoo user rating lookup within string.xlsx 9.6 KB · Views: 4
Hey guys- Looking to extract a value within a delimited string, based on value found in another cell in conjunction with hlookup table. Workbook should be clear..
Hui Excel Ninja Staff member May 9, 2016 #2 I'm note sure I totally understand the question but does =INDEX($B$4:$F$4,,MATCH(H5,$B$5:$F$5,0)) solve the problem?
I'm note sure I totally understand the question but does =INDEX($B$4:$F$4,,MATCH(H5,$B$5:$F$5,0)) solve the problem?