Change cell content depending on selection from drop down list

**RichPee** · 04-03-2015, 05:19 PM

Hi,

On sheet 2, I have cells A1:A12 labeled Jan, Feb through to Dec. In cells B1:B12 I have figures that relate to this month. On sheet 1, I want a drop down box that when I select a month then a cell will automatically populate the figure below the cell related to that month on sheet 2 - I have several rows with different figures on sheet 2 that would summarise on sheet 1 depending on the month selected from the drop down list on sheet 1.

I know how to create the list using Data Validation - but not sure how to get it to change the figures depending on which month I select from the drop down menu.

Can anyone help?

Many thanks,

**daffodil11** · 04-03-2015, 06:00 PM

I'd go with INDEX(..SMALL(IF array.

Where A2:A7 was my first column of things I wanted to return, C2:C7 was month name.

=IFERROR(INDEX(Sheet2!A$2:A$7,SMALL(IF(Sheet2!$C$2:$C$7=Sheet1!$B$3,ROW($C$2:$C$7)-1),ROW(A1))),"")

This is an array formula, confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Once entered, the formula was dragged over and down as needed.

Change cell content depending on selection from drop down list

LinkBack

Thread Tools

Rate This Thread

Display

Change cell content depending on selection from drop down list

Re: Change cell content depending on selection from drop down list

Thread Information

Users Browsing this Thread

Similar Threads

Vlookup to chose correct list depending on a drop down list selection

Single Cell Value From Either A Drop Down List Or Entered Manually, Depending On Selection

[SOLVED] Hide columns depending on a text selection in a drop-down list

[SOLVED] Hide rows depending on a selection in a drop-down list.

Change ws3 Cell Content Depending On ws1 Content

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions