Hi All - I've the "Item number" as lookup value in Col A. The values to be looked up (table array) is across multiple columns (6 columns). Ask: If the given item number exist in any of the 6 columns, then return the value of column 7. Tried multiple formulas including array but didn't get it done.. Can some one help? Appreciate it. PFA the excel file.
Reply With Quote
