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 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?
