Data Validation - List + Custom

[tlc53]

Hi,

The only data I would like inputted into cell F15 are numbers 840, 841,842, 843 & 844. Also, you can only input into this cell (F15) if cell B15 is populated.

Little stumped on this. Can someone help me with the data validation formula please?

Thank you!

 

[kweaver]

Try a customer data validation of this:

=AND(NOT(ISBLANK(B15)),OR(F15=840,F15=841,F15=842,F15=843,F15=844))

AND, uncheck "Ignore blank"

 

[tlc53]

Perfect! Thanks so much