Is it possible to perform a MATCH using more than one lookup value/range ?
=MATCH(A1,F:F,0) will return the row number if a match is found in column F of the value in A1
What if I want to find the row number when more than one match/column condition exists ?
=MATCH(A1,F:F,0) and MATCH(B1,G:G,0) must both be TRUE before the row number is returned
Thanks in anticipation