lookup row and column

  • Thread starter Thread starter n00batW0rk
  • Start date Start date
N

n00batW0rk

I have a table with dates going across,

and down column A, I have a set of names.


I have a similar table that i need to populate with the above data but
there are some additional dates as well as names. I cannot do a lookup
because if i lookup the name, it will return the wrong data because of
the addional dates, and vice versa with the lookup by date. If anyone
can help, Thank you.
 
n00batW0rk said:
I have a table with dates going across,

and down column A, I have a set of names.


I have a similar table that i need to populate with the above data but
there are some additional dates as well as names. I cannot do a lookup
because if i lookup the name, it will return the wrong data because of
the addional dates, and vice versa with the lookup by date. If anyone
can help, Thank you.
Click to expand...

Are you wanting to do a double-lookup? If so, this formula looks up A1(row)
and B1 (column) in an array named 'Table':
=INDEX(Table,MATCH(A1,INDEX(Table,,1),0),MATCH(B1,INDEX(Table,1,),0))
 
Back
Top