Try VLOOKUP.
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
VBA Project Manager
www.OfficeArticles.com

"Darin Gibson" <Darin wrote in message
...
I need to nest 10 IF functions.

According to Excel help:

Up to seven IF functions can be nested as value_if_true and value_if_false
arguments to construct more elaborate tests. See the last of the following
examples.

What else can I do?