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

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.
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?
 
Upvote 0
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)
 
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,167
Members
448,554
Latest member
Gleisner2

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
Back
Top