Hello Johannes

One way:

=INDEX(C2:I9,MATCH("Country",B2:B9,0),MATCH(Year,C 1:I1,0))

Data in C2:I9, countries in B2:B9 and years in C1:i1

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Johannes" skrev i en meddelelse
...
Hello all,

How can I look up a value in a matrix. First column has countries, first
row
has years. Am looking for value of specific country in specific year.
Thought about combinations of lookup and matches, but that does not make
it
any prettier. Any suggestions?

Any suggestions?