Drop down menu help

[NobukiEndo]

Hello,

I am working on a school project and would like to incorporate a drop down menu in my spreadsheet. I have 3 options in my drop down menu and depending on which one I choose I would like a different list of numbers to appear. So in my project I would like to select "Residential" in the drop down menu and I would like the numbers below residential to the right that I have inputted myself to appear as a list under the "Tenants" column to the left. I have added a picture for reference. Is this even a possible function of excel? This project is due on Monday Nov. 9 so any help would be greatly appreciated!

Capture.PNG

Thanks,
Nobuki Endo

[ChemistB]

Using the Name Manager, name the list under Residential as Residential, Commercial as "commercial, etc.

If your dropdown menu is data validation in cell E2 and the first cell for your numbers is E6

In E6
=IFERROR(INDEX(INDIRECT(E2), ROWS($E$6:$E6)), "")
Questions?

[José Augusto]

Hi
You can use OFFSET and MATCH to do that
=OFFSET($H5,1,MATCH($E$2,$I$5:$K$5,0))

[NobukiEndo]

ChemistB,
I am only ably to get a value to appear in my "initial cost" column but I want all of the values to appear from my table on the right. So if I were to choose "Residential" from the drop down I want "initial cost" to display 2, "operating cost" to display 4, "maintenance" display 4 and so on. Is there a way to do this?

[José Augusto]

Hi
You must copy the formula down

[NobukiEndo]

I got it working thanks for the help!