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

=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

Thanks for the help, it works fine. But, it turns out I need it to be a
little more complex. Can I add a third variable? The data is set out
like:


Y N
depA depB depC depD depA depB depC dep D
cat1
cat2
cat3


So far the formula selects the value at the intersection of dep and
cat. Can I add in a further bit where it will show the value of the
intersection of dep/cat IF they are in the Y bit?

Thanks again


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