Validation combined with CHOOSE function?!


New Member
Aug 3, 2010
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.

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:

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Sandeep Warrier

Board Regularmmmm Pizza
Oct 31, 2008
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?


Board Regular
Nov 23, 2005
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)

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Latest member

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...