Ted, this ARRAY formula does it
=INDEX(C:C,MATCH(1,($A$1:$A$20=$H$2)*($B$2:$B$20=$H$3),0))
Ted, this ARRAY formula does it
=INDEX(C:C,MATCH(1,($A$1:$A$20=$H$2)*($B$2:$B$20=$H$3),0))
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote