=INDEX(C1:C10,MATCH(1,(A1:A10="x")*(B1:B10="y"),0) )
entered with ctrl + shift & enter
where x and y are the 2 criteria for A and B
--
Regards,
Peo Sjoblom
Portland, Oregon
"RSantos" wrote in
message ...
HI
Iīve seen many solutions in the forum to use 2 or more conditions,
however either tehy donīt aply to my problem or I canīt understand
them. I need to get, for example, the value of col C based on the
values of col A and B.
Can anybody help?
Is there a way to do it with VBA?
Thaks
--
RSantos
------------------------------------------------------------------------
RSantos's Profile:
http://www.excelforum.com/member.php...o&userid=31240
View this thread: http://www.excelforum.com/showthread...hreadid=509663