IF statement data validation

[echoz]

Hi all,

Probably a simple one really I am trying to make a Data list with an IF statement attached.

Basically, if cell stated (going down respectively) is = AWOL. Then show word AWOL, otherwise give option of list

=IF(ManningData!$P$8= "AWOL","AWOL",+Tasks)

Currently getting error "The list source must be a delimited list, or a reference to a single row or column.

I thought this would work but not quite - The list is labelled as "Tasks"

Any help much appreciated

[JohnTopley]

Create named range "AWOL" (just AWOL in a cell)

For DV

=IF(ManningData!$P$8= "AWOL",AWOL,Tasks)

[The_Snook]

Hi echoz,

Try creating a named range called 'AWOL' that just contains 'AWOL' and then use this formula in the Data Validation -> List

=IF(ManningData!$P$8="AWOL",AWOL,Tasks)

This will give the AWOL drop down options if it's TRUE and the Tasks options if it's FALSE.

Hope this helps,

Snook

[echoz]

Thanks all your formulas worked but I ended up changing the way I handled it to suit situation slightly.

Good responses thanks

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.