"=IF" with more than 64 levels of nesting

[LONI]

I have the formula but how do I use the "Lookup" formula so I can have more than 64 levels of nesting?
I tried and I keep getting an error when I try to use the "Lookup" formula

The formula is:

=IF(B:B=Inventory!A2,Inventory!B2:D2,IF(B:B=Inventory!A3,Inventory!B3:D3,IF(B:B=Inventory!A4,Inventory!B4:D4,IF(B:B=Inventory!A5,Inventory!B5:D5,IF(B:B=Inventory!A6,Inventory!B6:D6,IF(B:B=Inventory!A7,Inventory!B7:D7,IF(B:B=Inventory!A8,Inventory!B8:D8,IF(B:B=Inventory!A9,Inventory!B9:D9,IF(B:B=Inventory!A10,Inventory!B10:D10,IF(B:B=Inventory!A11,Inventory!B11:D11,IF(B:B=Inventory!A12,Inventory!B12:D12,IF(B:B=Inventory!A13,Inventory!B13:D13,IF(B:B=Inventory!A14,Inventory!B14:D14,IF(B:B=Inventory!A15,Inventory!B15:D15,IF(B:B=Inventory!A16,Inventory!B16:D16,IF(B:B=Inventory!A17,Inventory!B17:D17,IF(B:B=Inventory!A18,Inventory!B18:D18,IF(B:B=Inventory!A19,Inventory!B19:D19,IF(B:B=Inventory!A20,Inventory!B20:D20,IF(B:B=Inventory!A21,Inventory!B21:D21,IF(B:B=Inventory!A22,Inventory!B22:D22,IF(B:B=Inventory!A23,Inventory!B23:D23,IF(B:B=Inventory!A24,Inventory!B24:D24,IF(B:B=Inventory!A25,Inventory!B25:D25,IF(B:B=Inventory!A26,Inventory!B26:D26,IF(B:B=Inventory!A27,Inventory!B27:D27,IF(B:B=Inventory!A28,Inventory!B28:D28,IF(B:B=Inventory!A29,Inventory!B29:D29,IF(B:B=Inventory!A30,Inventory!B30:D30,IF(B:B=Inventory!A31,Inventory!B31:D31,IF(B:B=Inventory!A32,Inventory!B32:D32,IF(B:B=Inventory!A33,Inventory!B33:D33,IF(B:B=Inventory!A34,Inventory!B34:D34,IF(B:B=Inventory!A35,Inventory!B35:D35,IF(B:B=Inventory!A36,Inventory!B36:D36,IF(B:B=Inventory!A37,Inventory!B37:D37,IF(B:B=Inventory!A38,Inventory!B38:D38,IF(B:B=Inventory!A39,Inventory!B39:D39,IF(B:B=Inventory!A40,Inventory!B40:D40,IF(B:B=Inventory!A41,Inventory!B41:D41,IF(B:B=Inventory!A42,Inventory!B42:D42,IF(B:B=Inventory!A43,Inventory!B43:D43,IF(B:B=Inventory!A44,Inventory!B44:D44,IF(B:B=Inventory!A45,Inventory!B45:D45,IF(B:B=Inventory!A46,Inventory!B46:D46,IF(B:B=Inventory!A47,Inventory!B47:D47,IF(B:B=Inventory!A48,Inventory!B48:D48,IF(B:B=Inventory!A49,Inventory!B49:D49,IF(B:B=Inventory!A50,Inventory!B50:D50,IF(B:B=Inventory!A51,Inventory!B51:D51,IF(B:B=Inventory!A52,Inventory!B52:D52,IF(B:B=Inventory!A53,Inventory!B53:D53,IF(B:B=Inventory!A54,Inventory!B54:D54,IF(B:B=Inventory!A55,Inventory!B55:D55,IF(B:B=Inventory!A56,Inventory!B56:D56,IF(B:B=Inventory!A57,Inventory!B57:D57,IF(B:B=Inventory!A58,Inventory!B58:D58,IF(B:B=Inventory!A59,Inventory!B59:D59,IF(B:B=Inventory!A60,Inventory!B60:D60,IF(B:B=Inventory!A61,Inventory!B61:D61,IF(B:B=Inventory!A62,Inventory!B62:D62,IF(B:B=Inventory!A63,Inventory!B63:D63,IF(B:B=Inventory!A64,Inventory!B64:D64,IF(B:B=Inventory!A65,Inventory!B65:D65,IF(B:B=Inventory!A66,Inventory!B66:D66)))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

 

[jolivanes]

Looks like you should rethink your approach.
Maybe show here in a concise manner what you want to accomplish and there will be someone with a better approach.

 

[Eric W]

Welcome to the forum!

Clearly there is a better way to do it than a huge formula. If your Inventory sheet looks like this:

Book1
	A	B	C	D
1	Code	Val1	Val2	Val3
2	a	1	6	11
3	b	2	7	12
4	c	3	8	13
5	d	4	9	14
6	e	5	10	15
7
Inventory

You can do something like this:

Book1
	A	B	C	D	E
1
2		a	1	6	11
3		x	#N/A	#N/A	#N/A
4		b	2	7	12
5		y	#N/A	#N/A	#N/A
6		c	3	8	13
7		z	#N/A	#N/A	#N/A
8
9
Sheet8

Cell Formulas
Range	Formula
C2:E7	C2	=INDEX(Inventory!$B$2:$D$66,MATCH(B2,Inventory!$A$2:$A$66,0),0)
Press CTRL+SHIFT+ENTER to enter array formulas.

Much shorter formula. There are a couple of interesting points with your original formula. You're using B:B=Inventory!A2, which seems to indicate you're using implicit intersection. That has been reimagined in newer versions of Excel, and should be avoided. I just used the B2 value for matching. Then you're returning a 3-column result, so I put displayed that by selecting the 3 columns and using Control+Shift+Enter.

If this does not reflect what you want, please try to explain a bit clearer. If you use the XL2BB tool, like I just did, it's much easier to explain what you want. You can download it from my signature, or the response box. It's easy to download, install, and use.