Is it possible to have excel perform a match lookup in 3 different columns?
i have cell M14 that is doing an index Match function and is matching cell D14 and cell M8in sheet "7-4-10" thru column D and column B on another worksheet ("Weekly Total") in the same book.
But can it perform this same match looking thru column B, L, and V in sheet "Weekly Total" to match cell D14 in worksheet "7-4-10" and look thru column D, N, and X in sheet "Weekly Total" for cell M8 in sheet "7-4-10".
And if it finds the match then return the value from in column H, R, or AB in sheet "Weekly Total"?
Bookmarks