Hello!
In column A and B I have values. I need a formula that can look at column A and column B and find certain values I specify. For example, I need the formula to find "2" in column A and "1948" in column B. Once it finds those values I would like it to return values I specify to 3 different adjacent cells. For example, the formula finds "2" and "1948" in cells A2 and B2. It then returns "1" to cell D2, "2" to cell E2, and "3" to cell F2.
Any help is greatly appreciated. Thanks! Lookup Multiple Columns.xlsx
Bookmarks