Excel 2016 Advanced Lookup & Reference Functions

Dr. Syed Farhan, Training Manager / IT Coordinator / IT Trainer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
6 Videos (24m)
    • Using VLOOKUP with large tables

      4:21
    • Using MATCH and INDEX functions together

      4:14
    • Retrieving information by location

      2:53
    • Nesting lookup functions

      4:12
    • Looking up information with VLOOKUP and HLOOKUP

      4:30
    • Locating data with the MATCH function

      3:43