If's against Vlookups

What is the other option once you have hit the seven if's limitation?

What's the question? Do you have an example of what you are trying to do?

Originally Posted by Paul Morgan

What is the other option once you have hit the seven if's limitation?

Obviously you know there is a seven nested if limit, After that try a Vlookup
Here is a 7 nested if formula
=IF(A2=1,"a",IF(A2=2,"b",IF(A2=3,"c",IF(A2=4,"d",IF(A2=5,"e",IF(A2=6,"f",IF(A2=7,"g","Max number of nested If's allowed")))))))
Here is a vlookup Formula
=IF(ISERROR(VLOOKUP(A2,Data,2,0)),"Item Not Found",VLOOKUP(A2,Data,2,0))

Here is an example

Thank You very much
it is what I was looking for,
I am wondering if there is there a way to do vlookup without having to create a table

If you need more than 7 if statement it's easier to use a vlookup. There are workarounds as per links

http://www.usd.edu/trio/tut/excel/adv/26if.html

http://www.j-walk.com/ss/excel/usertips/tip080.htm

http://www.cpearson.com/excel/nested.htm

If dealing with numbers you could look at Choose function

http://www.techonthenet.com/excel/formulas/choose.php

But as oldchippy says better to give an example of the problem

VBA Noob