is it possible to make an Excel drop down list with word used as a term by Excel.? -

i make drop down list based on cell contains true or false

what if cell value true (cell t1) show list , if cell value false show cell value

i'm pretty aware true , false cannot used cell name cannot apply indirect function

how can approach issue ?

thank

a solution suggest use condition on validation range - , not on cell in question.

for example if had true/false in a1 use:

=if($a$1=true,"a","b") 

for each of intended conditions.

if didn't want different list value, use #n/a or blank, or point cell reference

then point data validation list function @ range. change condition changes