Thread
:
vlookup to see 2 values?
View Single Post
#
6
MikeY
Posts: n/a
D1: {=INDEX(C$1:C$4,MATCH(1,(A$1:A$4=A1)*(B$1:B$4=B1), 0),1)}
Your wrong formula must be equivalent to;
{=INDEX(C$1:C$4,MATCH(1,(A$1:A$4=A$1)*(B$1:B$4=B$2 ),0),1)}
--
Mike
wrote in message ...
Reply With Quote