VLOOKUP Incorporating Other Excel Functions

The application of lookup functions can be enhanced by combination with other Excel functions.

Functions such as MAX and MIN can be used in a VLOOKUP formula to return a value in a table matching the function used.

Highlights

Explore a lookup table suited to using a VLOOKUP formula incorporating another Excel function
Create a VLOOKUP function incorporating the MAX function
Use a named range within a VLOOKUP formula

Duration: 6mins 29secs

from