One way:

Assuming the column/row you want to look up is in K1/K2, respectively,

=VLOOKUP(K2,A1:J6,MATCH(K1,A1:J1,FALSE),FALSE)


or, if you named your table "table":

=VLOOKUP(K2,table,MATCH(K1,OFFSET(table,,,1,),FALS E),FALSE)



In article ,
"artland" wrote:

If I have a table with column headings and row headings that are different
and I want to find out the information for a particular cell based on what is
in those headings, how would I do that. i.e. if I had columns marked 1-10
and rows labled 2005 - 2010 how would I find the information of the cell that
matched column 6 and row 2008?