Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Choosing data based on Match to several items
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return multiple rows of data based on criteria | Excel Worksheet Functions | |||
How to Match and Sort two range of data? | New Users to Excel | |||
Sort pages? | Excel Discussion (Misc queries) | |||
How do I get a pivot table to sort based on the data items sectio. | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |