Help with VLOOKUP and formulas

[Sweenus]

Is it possible to use a VLOOKUP with multiple constraints or to write a formula in Excel that contains more than 8 functions, more like 16 functions?

 

[scifibum]

According to Excel help, you can only have 7 levels of nested functions. However, this applies to "levels" not the total number of functions that you can have in one formula. Since some formulas accept multiple arguments, such as the "AND" and "OR" functions, and all the arguments for that function are on the same "level", you can have a lot of functions in one formula.

Here's an example of one with about 20 functions, which works fine, since it only contains 3 levels:

=IF(AND(SUM(C1:C10)>5,SUM(D1:D10)>5,SUM(E1:E10)>5,SUM(F1:F10)>5,SUM(G1:G10)>5,SUM(H1:H10)>5,SUM(I1:I10)>5,SUM(J1:J10)>5,SUM(K1:K10)>5,SUM(L1:L10)>5,SUM(M1:M10)>5,SUM(N1:N10)>5,SUM(O1:O10)>5,SUM(P1:P10)>5,SUM(Q1:Q10)>5),IF(TODAY()<DATEVALUE("1/25/2005"),5,0),4)

To do something equivalent to VLOOKUP with multiple conditions, see one of these pages:
http://www.cpearson.com/excel/lookups.htm#DoubleLookup
http://www.mrexcel.com/board2/viewtopic.php?t=120597
http://www.mrexcel.com/board2/viewtopic.php?t=110384

 

[Brian from Maui]

Is it possible to use a VLOOKUP with multiple constraints or to write a formula in Excel that contains more than 8 functions, more like 16 functions?

What is it that you want to do?

 

[Sweenus]

Thank you for all your help, I was able to combine the VLOOKUP with some IF and OR statements in order to fit all the data I needed