The LOOKUP Function

This lesson introduces the LOOKUP function.

The start times of various sections within the video are listed below.

Video sections and timestamps:

  1. Introduction to the LOOKUP function
  2. Lesson outline (0:00)
  3. General explanation (0:14)
  4. Simple example (0:42)
  5. Ascending order requirement (1:28)
  6. Example with inexact match (1:39)
  7. Example with unordered 'lookup vector' (does not work) (2:21)
  8. Text example (3:26)
  9. Column example (3:53)
  10. Example with 'lookup value' too small (does not work) (4:32)
  11. Example with two arguments (4:53)
  12. The LOOKUP function help article (5:26)