How do you combine IF, LOOKUP and MATCH to come up with a formula in these conditions
If A7 is equal in any rows in sheet 2 column A, B6 is equal to any rows in sheet 2 column B, and A3 is equal to any rows in C, then return the value of sheet 2 column D.
Thanks!
Bookmarks