Multiple IF statements

Question

Hi,&nbsp;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.&nbsp;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?&nbsp;Thanks in advance.&nbsp;

oliverscheurich · Answer

SophieBill&nbsp;You can try doing this with named ranges and with the INDIRECT function.

riny_van_eekelen · Answer

SophieBill&nbsp;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.&nbsp;

sophiebill · Answer

thank you i will give it a go

Forum Discussion

Multiple IF statements

3 Replies

Resources