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