Hi Guys,
Basically what I'm wanting to do is add multiple IF statements to 3 cells within a spreadsheet.
Cell A has a list of 6 outcomes via the validation and works fine.
Cell B has around a choice of 30 outcomes which have been shorted via an IF statement relating to your answer at cell A.
Cell C I want to have around 200 outcomes which again I want reduced via an IF statement relating to your answer at cell B.
The problem I'm having is in relation to the amount of space I have to write the IF statement, basically I've ran out of room within the data validation.
My question is,
Can this be done?
Is there a better way of doing this without designing an assess database?
Cheers
Neil
Bookmarks