Get text or number from an external table
The function CELL can be used within lookups and formulae to get text or a number from a table.
To use the CELL function the table must exist and be set with the correct values
Cell function format:-
CELL(table name,row name,column name)
To get a value use the expression in a formula:-
CELL(DOOR,OAK,600)
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 |
So the above formula would give an answer of 15.50
Can also use variables and lookups:-
CELL(DOOR,$STYLE$,@SIZE@)
Cell function in Lookups evaluates to a text value
Cell function in formula evaluates to a number