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