Forum Discussion
Idex Match
Hi Guys, Im trying to do an index match on the below data to try and look up from the description in column J to match what's in columns B/C and to return the item in column A. The formula...
Adjust the ranges as needed, but don't use entire columns in the following formula.
=IFERROR(INDEX($A$2:$A$100,MATCH(1,($B$2:$B$100<>"")*ISNUMBER(SEARCH($B$2:$B$100,J2)),0)),"")