a list, based on an IF statement

[kaitewright]

Okay,


I want to be able to create a list based on an IF statement.
For example, i want to have a list validation for all clients, but if a cell is equal to a client code, then reduce the list to only that client...

does this make sense?

If so ... how (if possible avoiding vb).

Ta Kaite

[davesexcel]

You may want a dependant dropdown list check out this site

http://www.contextures.com/xlDataVal13.html