Field at the Look-up table
The value is typically a fixed value (number or text) but can also be a formula.
- Enter the value or constant for the item in the look-up table.
The value can also use variables so that the definition can depend on answers at Product requirements.
With the Cell function:-
Lookup table
Name |
Description |
Value |
EDGEMATERIALDOOR |
Edging material for doors |
=CELL(DOOR,@DOORMAT@,@DOORSIZE@) |
With text manipulation functions:-
Lookup table
Name |
Description |
Value |
MATERIALDOOR |
Door material |
=LEFT(@DOORMAT@,4) |
