=INDEX(array,MATCH(x, col as range,0),MATCH(y, row as range,0))

"sanders" wrote:


Hi,
Is there a way to get data based on two variables? The data I want is
in an array format, so I am trying to get the value of a cell at the
intersection of two variables. Will I have to use Vlookup and Hlookup
in the same formula?


Thanks


--
sanders
------------------------------------------------------------------------
sanders's Profile: http://www.excelforum.com/member.php...o&userid=36745
View this thread: http://www.excelforum.com/showthread...hreadid=566540