...
Filter rows that have column “Value” = the lookup key AND:
The value of “From” >= Quote Start Date,
OR “From” is empty.
Ordering the resulting rows ascendingly
Notes: empty value is always at the end of the order list.
NOTES: The standard Date format for column “From” is dd/MM/yyyy
GIVEN we have the VehicleAge lookup as below.
...