Types of Lookup Tables

After opening the New lookup table wizard, you need to select the desired lookup table type.

Lookup Table Whole Table in Memory Allows Duplicated Key Values
Table 24. Types of Lookup Tables

Yes

Yes

No

Yes

Yes

No, but intervals may overlap

No

Yes

Yes

Yes