I was asked which method of lookup call would be the best way to follow.

Currently we only have a small amount of test data so it's even across the board.

Lookups here are for the most part STATIC and SMALL. Coders are considering putting the Lookups in code in a case statement, or writing a UDF() or doing a join.

Price Type has 4 possibilities.
Regions have 12.

If your going to bring in those 2 tables lookup descriptions for a report that is processing say 2,000 to 24,000 rows, is it beneficial to get that Text Value by :
1) Case
2) UDF()
3) Join

TIA

__Stephen