View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid vezerid is offline
external usenet poster
 
Posts: 751
Default 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?