Use VLOOKUP instead. Check the help for vlookup.

Mangesh



"How do I put in more than 7 validations" <How do I put in more than 7
validations @discussions.microsoft.com wrote in message
...
I have an excel sheet wherein I have a column in which I need to put in 30
validations . But the IF function is with 7 validations max. How can I do
a
IF function with 30 validations