Thanks for your suggestion. I actually came up with about the same answer
except I decided to convert the five data points into a unique number by
multiplying the first data point by 10,000, the second by 1,000, the third by
100 and so on.

Thank you very much, everyone, for your responses.

Nipper

"Miguel Zapico" wrote:

If you can use an additional column, one solution can be creating a
concatenation of the codes, and the use VLOOKUP over it.
In your example, to create the column you may use:
=CONCATENATE(A2,B2,C2,D2,E2)
And to query it (supposing the 5 entry points are in A7:E7 and the new
column is in F, with the data on their right), something like:
=VLOOKUP(CONCATENATE(A7,B7,C7,D7,E7,),$F$2:$K$4,2, FALSE)

Hope this helps,
Miguel.

"Nipper" wrote:

I have a range of data that is organized based on 5 data points. I would
like to develop a formula the chooses the proper data based on the values in
the five data points. Is there an easy way to do that? I have looked at the
Choose, Match, and Index functions and none seem to do what I'm wanting them
to do. Below is an example of my spreadsheet:

Data Table
Data Points Data
2006 2007 2008 2009
2010 ...
1 1 3 0 1 5 6 5
4 3
1 2 1 0 1 7 8 6
4 2
2 1 2 0 0 10 12 9
7 5

Selected Data (what I want to see)
1 2 1 0 1 7 8 6
4 2