Hi All,
This is my first post as this is the first time I couldn't find an anwser already posted
I'm trying to validate 2 cells and if both matches it should return a value from column 3
I've gotten so far as it would return a error when criterea is not met.
However is it finds a match it always returns the first value.
My current formula is: =INDEX($C$24:$C$29,(AND(MATCH(A12,$A$24:$A$29,1),MATCH(B12,$B$24:$B$29,0))))
I can't find a way to make Excel validate the first 2 columns and return the value from column 3.
Any help would be greatly appreciated.
Bookmarks