Lookup to populate table headings

Hi,

I have a dashboard in which the user can select All, Branch 1, Branch 2, Branch 3 etc to Branch 6.

Depending on the selection I need it to pull in data headings to be used on my dashboard – would a lookup do this?

I have uploaded an example which should explain it more clearly but this is what I want to achieve...

If branch one or two is selected it would display the following in the blue box on the dashboard (Cell B80):
INVENTORY ANALYSIS
Campaign
Commodity including Downstream finished goods
Automotive
Buffer Stock
Raw Materials, work-in-progress and stores

If branch 3, 4, 5 or 6 is selected it would display the following in the blue box on the dashboard (Cell B80)
Raw glass
Interlayer
Other raw materials
Semi-finished - goods in transit
Semi-finished product awaiting further processing
Work-in-progress - within production process
Finished goods
Trading Goods
Trading goods in transit
Maintenance spares
Other stores
TOTAL NET STOCK

If all is selected then the blue box on the “dashboard” sheet would display all of the above (As in the example of the spreadsheet - not displayed here)

The branch selection is linked to cell D4 on the “Calcs” sheet

All the lists can be found on the “Calcs” sheet range C97:C114

Any suggestions?

Hi,

I tried using this IF formula but it didn’t work:

Please Login or Register  to view this content.

As I need to set the max number of rows e.g. If 1 then restrict it to 19 rows from cell C123, if 2 or 3 then restrict to 6 rows from cell C158, if other max rows should be 13 from C145

Can anyone help – I am unsure if this is the best way to achieve what I need.

Anyone? ive searched the internet for something similar so if somore could just point me in the right direction I would apprechiate it

I have come up with the formula below - does anyone know of a cleaner way?

Please Login or Register  to view this content.

Excellent - thanks NBVC!! The formula where I do have to manually change every line will save me time as previously I manaully changed each one.