Hi,

Is it possible to put an IF statement in the data validation?
I want the list to be determined by the value in a particular cell, so:
Basically what I need it to do is look at cell A1, if cell A1 say "food" then i want a dropdown box in B1 with a list of my choosing
If cell A2 says "Utility" then i want a dropdown box in B1 with a list of my choosing, which is to be different to the list available if A1 said food.

Many thanks

L