Hi,

Excel <=2003 allows a maximum of 7 levels of nesting. Alternatives:
1. Upgrade to 2007 for 64 levels deep
2. Switch from this multiple IF to a VLOOKUP.
3. Create the deep nesting in Lotus 1-2-3 or Quattro Pro and save it as an
Excel file and open it in Excel.

--
Thanks,
Shane Devenshire


"SeeStation" wrote:

=IF(C233=Sheet1!D17,Sheet1!C17,IF(C233=Sheet1!D18, Sheet1!C18,IF(C233=Sheet1!D19,Sheet1!C19,IF(C233=S heet1!D20,Sheet1!C20,IF(C233=Sheet1!D22,Sheet1!C22 ,IF(C233=Sheet1!d23,Sheet1!C23,IF(C233=Sheet1!D26, Sheet1!C26,IF(C233=Sheet1!D27,Sheet1!C27,IF(C233=" Choose Card Set","Choose Card Set","Not Available"))))))))))

Gives an error - only thing I can think of is it is too long?
Any suggestions? If it is too long is there another way to make this work?
You guys are great! Thanks in advance.