Lookup

[sanders]

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


Thank

 

[Guest]

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

 

[sanders]

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