# Help with VLOOKUP and formulas

#### Sweenus

##### New Member
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?

### Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
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:

Code:
``=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

Sweenus said:
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?

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

Replies
8
Views
697
Replies
3
Views
307
Replies
1
Views
268
Replies
19
Views
776
Replies
4
Views
180

1,196,274
Messages
6,014,390
Members
441,818
Latest member
itsfaisalkhalid

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back