Formular Is Too Long

[[email protected]]

I tried to enter the following formular into a cell and become the
message "The formular is to long" if I delete some of the values it
works fine. I knew that there was a limit on IF statments but not for
Lookup values. Would anyone know a way around this, or if it is
possible to use VBA to do the same as the formular.

=3DIF(ISNUMBER(1/(LOOKUP(CJ27,FNums)))*(AND(CJ13=3D"With")),CHOOSE(LOOKUP(C=
J27,FNums),"F-N=B0
1 With Backing","F-N=B0 1, & 2 With Backing","F-N=B0 1, 2, & 3 With
Backing","F-N=B0 1, 2, 3, & 4 With Backing","F-N=B0 1, 2, 3, 4, & 5 With
Backing"),IF(ISNUMBER(1/(LOOKUP(CJ27,FNums)))*(OR(CJ13=3D"With",CJ13=3D"Wit=
hout")),CHOOSE(LOOKUP(CJ27,FNums),"F-N=B0
1 With & Without Backing","F-N=B0 2 With & Without Backing F-N=B0 1
With","F-N=B0 3 With & Without Backing, F-N=B0 1 & 2 With","F-N=B04 With
or Without Backing F-N=B0 1, 2 & 3 With","F-N=B05 With & Without F-N=B0 1,
2, 3, & 4 With "All F-N=B0 6 Filler Metals","All F-N=B0 21 through F-N=B0
25 Filler Metals","Only F-N=B0 "&CJ27&" Filler Metals","Only F-N=B0
"&CJ27&" Filler Metals","Only F-N=B0 "&CJ27&" Filler Metals","Only F-N=B0
"&CJ27&" Filler Metals","Only F-N=B0 "&CJ27&" Filler Metals","Only F-N=B0
"&CJ27&" Filler Metals","F-N=B0 34, and F-N=B0 41 through F-N=B0 45 Filler
Metals","All F-N=B0 51 through F-N=B0 55 Filler Metals","All F-N=B0 61
Filler Metals","Only F-N=B0 "&CJ27&" Filler Metals","Only F-N=B0 "&CJ27&"
Filler Metals"),CJ27))

Regards
MArtin

[davesexcel]

I am not quite sure what this is ,
Maybe you could check out this site VLOOKUP and see if it could help you,

http://www.contextures.com/xlFunctions02.html

[[email protected]]

Your right I should have explained what it does. I have put a
simplified version below.

It is comparing the value of a single cell to multiple values, it is
based upon a Lookup Worksheet that has a 2 Column range defined as
FNums

1 1
2 2
3 3
4 4
5 5
6 6
21 7
31 8
32 9
34 10
41 10
42 10
43 10
44 10
51 11
61 12
71 13

=IF(ISNUMBER(1/(LOOKUP(CJ27,FNums)))CHOOSE(LOOKUP(CJ27, FNum),"Text
based upon results of lookup", "Text based upon reslults of lookup",
etc......), "CJ27")

Martin

davesexcel wrote:
> I am not quite sure what this is ,
> Maybe you could check out this site VLOOKUP and see if it could help
> you,
>
> http://www.contextures.com/xlFunctions02.html
>
>
> --
> davesexcel
>
>
> ------------------------------------------------------------------------
> davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
> View this thread: http://www.excelforum.com/showthread...hreadid=574439