Forum Discussion
Multiple IF statements
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 f...
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.