Use this array formula
=IFERROR(INDEX($F$1:$F$12,MIN(IF(ISNUMBER(SEARCH($E$1:$E$12,A1)),ROW($E$1:$E$12),99))),".")
Use this array formula
=IFERROR(INDEX($F$1:$F$12,MIN(IF(ISNUMBER(SEARCH($E$1:$E$12,A1)),ROW($E$1:$E$12),99))),".")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks