Usually, I use a separate table of info on a different sheet.

Then I use =vlookup() to return what I want.

But it depends on what you're doing.

You may want to read Debra Dalgleish's notes:
http://www.contextures.com/xlFunctions02.html (for =vlookup())
and
http://www.contextures.com/xlFunctions03.html (for =index(match()))

Kathy wrote:

What do you do if you have a formula you need to enter that is more than 9
"IF" statements!!!! It won't allow more than 9 "IF statements in Excel and
it is so frustrating!!

--

Dave Peterson