Occurs for Optimising if the CELL function is in use in a formula
The argument (when used in a Look up) is greater than 80 characters
For example if using the table:-
##DOOR,500,600,800
OAK,RECESS,PLAIN,RECESS
GREY,RECESS,GABLE,PLAINXXXX.....XXXXX
TEAK,RECESS,PLAIN,PLAIN
The following cell formula produces this error.
=CELL(DOOR,800,GREY)
Since the item in the location GREY/800 is more than 80 characters
|
33099 |