Forum Discussion
Solved
How can I use XLOOKUP to find the cell with a contains?
I have a table that has a cell that concatenates groups. This cell may have multiple values and they're not always in the same order due to the program that spits them out. Name Group (desir...
=INDEX($G$3:$G$6,XMATCH(TRUE,ISNUMBER(SEARCH($G$3:$G$6,B2))))
This formula works in my Excel for the web sheet.
=INDEX($G$3:$G$6,XMATCH(TRUE,ISNUMBER(SEARCH($G$3:$G$6,B2))))
This formula works in my Excel for the web sheet.
That's exactly what I needed! I figured the answer was going to use something other than XLOOKUP. I'll keep INDEX and XMATCH in my toolbelt from now on.
Thank you
Thank you