Cell argument not found

 

Occurs for Optimising if the CELL function is in use in a formula

 

The argument specified is not in the table.

 

For example if using the table:-

 

##DOOR,500,600,800         

OAK,12.99,15.50,17.90

GREY,9.00,12.00,15.00

TEAK,11.50,12.50,13.50

 

The following cell formula produces this error.

 

=CELL(DOOR,400,GREY)

 

Since there is no column in the table for 400mm doors

 

 

33096