Forum Discussion
How do I use Excel to show a list from a sheet in a second column, dependant on the first column?
Hi - I have a drop down list in column A - lets say 1, 2, 3, 4. That list relates to one of 4 sheets of data, say sheet 1, sheet 2, etc If I select 1, I want it to only show a list of data f...
Please attach your sample file with sample data and sample results.
Twifoo here you go
If without cosmetic when
=CHOOSE($C$2,'Sheet 1'!$A$1:$A$4,'Sheet 2'!$A$1:$A$4,'Sheet 3'!$A$1:$A$4,'Sheet 4'!$A$1:$A$4)
in data validation
