Index Match to match values separated by comma from a list, with each match reporting a separate value within one cell. See below. Thanks.
Reference cell = H10.32, J01.90, H65.199
Reports = left conjunctivitis, acute sinusitis, non suppurative OM
Current formula only returns one value or "N/A"
=INDEX('ICD-10'!E3:E440,MATCH(Table1[[#This Row],[ICD-10]],'ICD-10'!D3:D440,0))
Bookmarks