V lookup and H lookup together
=INDEX(data,rownumber,colnumber)
data is a 2D array. row- and colnumber are either supplied as
constants or are computed by MATCH, if you need to locate row and
column by looking up.
HTH
Kostis Vezerides
On Feb 15, 6:54 pm, Sissy wrote:
Is it possible to do a v lookup and an h lookup at the same time? For
example I want to find the data that matches the row and column of the cell
I'm in?
|