Validation combined with CHOOSE function?!

calibanzwei

New Member
Joined
Aug 3, 2010
Messages
1
Hi there,
For reporting purposes I need to pull information from different cells/sheets into one...

Basically I have a drop down box for the months and tabled areas for the information – choose ‘July’ and I need to pull information from specific cells on different sheets onto the 'Report' sheet, which can then be printed off.

<o:p></o:p>
I’ve been playing with CHOOSE but I don't think it'll work...<o:p></o:p>
<o:p> </o:p>
=CHOOSE(D2=July, C6=Summary!C20, D6=Summary!D20)<o:p></o:p>
<o:p> </o:p>
Select July and in C6 put the info from ‘July’ sheet cell C20.....and so on...


It's driving me crazy...and I probably haven't explained it too well :LOL:
 

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

Sandeep Warrier

Well-known Member
Joined
Oct 31, 2008
Messages
2,672
Hi & welcome to the Board!

What does the data look like in the other sheets? Is there a relation between the value selected in the drop-down and the sheets?

For example: You say that selecting July should display C20 and D20 from Summary. What is the relation here? What if you select August?
 

wesimmo

Board Regular
Joined
Nov 23, 2005
Messages
149
As above, you probably need to post more info, but i would think that INDEX will help.

If you use

=INDEX(data range, row number, column number)

Where :-

Data range is the table of data you need to return the values from.
Row number will be the output of the Drop Down, IF i assume that the range of data is the same range you use a column of to populate the drop down?
Column number may be hard coded or may be a reference to a cell with the column number you want to return.

Therefore assuming that the data table is A1:E12

Your drop down input range is A1:A12
Your drop down output is A20

Your INDEX would be something like...

=INDEX($A$1:$E$12, $A$20, Which column from the data)
 

Watch MrExcel Video

Forum statistics

Threads
1,132,741
Messages
5,655,028
Members
418,171
Latest member
ramiroayala

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top