FINDITEM multiple columns
I was wondering if there is a way we can use FINDITEM to find a value from multiple columns.
The way FINDITEM works is by comparing a list with a specific line item (column). However, in this case, I need to be able to find an item that may be in column 1 or column 2 or 3. Is there a way to achieve this? Any other option if FINDITEM does not work?