Forum Discussion
Adding a wildcard to a formula
Hello, I am trying to create a search cell for my spreadsheet to search within multiple columns and rows of a table and return the column header of the matched cell. The formula works with only e...
Something like this maybe. It can be folded up a bit more but this is the idea:
=UNIQUE(BYCOL(colors,LAMBDA(col,IF(ISNUMBER(XMATCH("*"&L1&"*",col,2)),TAKE(col,1),""))),1,1)
Something like this maybe. It can be folded up a bit more but this is the idea:
=UNIQUE(BYCOL(colors,LAMBDA(col,IF(ISNUMBER(XMATCH("*"&L1&"*",col,2)),TAKE(col,1),""))),1,1)
Thank you! This worked perfectly.
- Glad it worked. You're welcome!
