Multiple IF statements

[SophieBill]

Hi,

I want a user to be able to go onto this sheet and click what they need from the drop down in D3 and for the relevant table on Sheet 3 to be displayed.

I looked at using an IF statement for one option =IF(D3="IPC 4101 /21",Sheet3!D4:D14,"")

But i have just over 20 drop down options, i thought about just doing one continious if statement but i am aware of problems and it being time consuming. Is there any easier way i can do this?

Thanks in advance.

[#2]

@SophieBill 

You can try doing this with named ranges and with the INDIRECT function.

[#3]

@SophieBill As an alternative (and assuming that your Excel version supports dynamic arrays), restructure the data like in the attached file. and use UNIQUE and FILTER.

[#4]

thank you i will give it a go