Indirect Function

Likith

New Member
Joined
Dec 26, 2018
Messages
8
Hello ,

I would like to know how to fill the data based on drop down input .

For example I have named range as below

Apple
oranges
Grapes
banana

Name range of above data is "Fruits "

Water
Thumbs up
Tea
Coffee

Name range of above data is "Beverages"

Here is the deal , When I select "Fruits" from drop down then cells below the drop down should fills with above data (5 cells below that )
When I select "beverages" from drop down then cells below the drop down should fills with above data (4 cells below that )

Do you have any formula or code that we can do , I have tried few ways with indirect function but no luck .

Thanks in advance .

Cheers
 

Some videos you may like

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

Watch MrExcel Video

Forum statistics

Threads
1,108,969
Messages
5,525,963
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top