Function =IF statment limits
=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.
|