Dear Dave

Your solution worked perfectly - thank you so much!

All the best, Ian

"Dave O" wrote:

I mocked up some data like this: Country name (indicated by your
dropdown) in A2, and a Year (also indicated by your dropdown) in B2.
In G1 I have a label "Country", then in H1:J1 I have some year
numbers. In H2:J4 I have some data.

The formula I used is:
=VLOOKUP(A2,$G$2:$J$4,MATCH(B2,$H$1:$J$1,0)+1,0)

The MATCH is nested in the VLOOKUP as the column number argument. The
+1 augments the integer returned by MATCH to account for the "Country"
column.

Dave O
Eschew obfuscation