Hi All,
I am working on an educational game for a classroom but I am having an issue with an area lookup. I spent hours searching for a way to do this yesterday but turned up nothing.
AS per the below table, I essentially need a reverse index/match. Instead of typing in UK and 1910 and getting "6", I want to type in "6" and get "UK, 1910".
The idea is that I will have a random number generator - between 1 and 16 (it's actually 1 and 500 in the real game) and when a number is generated it returns the country and date as per the below. Because lookup/index/vlookup etc all seem to only return the value of the first column or row, I'm at a loss on how to make this work. Any ideas?
USA UK AUST CANADA
1900 1 5 9 13
1910 2 6 10 14
1920 3 7 11 15
1930 4 8 12 16
Bookmarks