LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nipper
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
return multiple rows of data based on criteria steve_sr2 Excel Worksheet Functions 8 May 20th 23 07:47 PM
How to Match and Sort two range of data? Tan New Users to Excel 1 March 5th 06 10:30 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
How do I get a pivot table to sort based on the data items sectio. Steve Excel Worksheet Functions 2 April 11th 05 05:03 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM


All times are GMT +1. The time now is 08:08 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"