How can I lookup and return labels from a table in excel?-CodePudding

I would like to return the labels in column F to column C, using column B and E, even though column E has multiple req IDs in some cells? I know I can't use a V Lookup in this case. However is there another formula or lookup function that I could use, to return the labels?

CodePudding user response：

Append a comma to both the find_text and search_text arguments to deal with the comma separated data in column E

B2: =INDEX($F$2:$F$7,MATCH(TRUE,ISNUMBER(FIND(TEXT(A2,"0\,"), $E$2:$E$7 & ",")),0))

CodePudding user response：

So, try:

IFERROR(INDEX($E$2:$E$7,MATCH(A2,$D$2:$D$7,0)),"Check")

Used iferror() to put "check" as a reminder to make sure "new" numbers are added to the list...