Sep 22 2021 09:04 PM
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 formulas seems to work and pulls in the correct info. however if column B is blank the data just pulls in the wrong data and duplicates it.
Could anyone advise or maybe tell me a better way to look up the data in column J to B/C?
Thanks
Sep 23 2021 01:22 AM
Sep 23 2021 01:31 AM
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)),"")