When a lookup table is used with a range of values the compare values must be sorted in alphabetical order if they are text.

Name: When a lookup table is used with a range of values the compare values must be sorted in alphabetical order if they are text.
Brand: Quizplus
Rating: 5.0 (39 reviews)

Question

Quizplus · Accepted Answer

Lookup tables are used to quickly find a value based on a given key. When using a range of values, the compare values must be sorted in alphabetical order if they are text to ensure that the correct value is found.

When a Lookup Table Is Used with a Range of Values