Excel LOOKUP Function

This Excel video teaches how to use the LOOKUP function in Microsoft Excel. The LOOKUP function searches for a value in a table array and returns a value from the same position in a specified row or column. The formula =LOOKUP(G5, B6:D12, C6:C12) is explained, with G5 being the value to search for in the first column of the table array (B6:D12) and C6:C12 being the result vector where the function will return a value from the same position in the table array, but from the corresponding row in the C column. The LOOKUP function works based on approximate match, finding the nearest value that is less than or equal to the lookup value in the table array.

EXCEL PRIMED RECOMMENDED COURSES

**Excel Essentials - The A-Z Guide for Advanced Users:
https://excelprimed.com/courses/excel-a-z-guide-for-advanced-users/

**Excel Essentials - The A-Z Guide for Beginners Level I:
https://excelprimed.com/courses/excel-a-z-guide-for-beginners-level-i/

**Excel Essentials - The A-Z Guide for Beginners Level II:
https://excelprimed.com/courses/excel-a-z-guide-for-beginners-level-ii/

**Excel Essentials - The A-Z Guide for Intermediate Users:
https://excelprimed.com/courses/excel-a-z-guide-for-intermediate-users/

**Excel Formulas - Advanced Level I:
https://excelprimed.com/courses/excel-advanced-formulas-level-i/

**Excel Formulas - Advanced Level II:
https://excelprimed.com/courses/excel-advanced-formulas-level-ii/

**Excel Formulas - Beginners Level I:
https://excelprimed.com/courses/excel-formulas-for-beginners-level-i/

**Excel Formulas - Beginners Level II:
https://excelprimed.com/courses/excel-formulas-for-beginners-level-ii/

**Excel Formulas - Intermediate Level I:
https://excelprimed.com/courses/excel-formulas-intermediate-level-i/

**Excel Formulas - Intermediate Level II:
https://excelprimed.com/courses/excel-formulas-intermediate-level-ii/

**Excel Data & Text Manipulation - Advanced Users:
https://excelprimed.com/courses/excel-advanced-data-text-manipulation/

**Excel Data & Text Manipulation - Beginners:
https://excelprimed.com/courses/excel-beginner-data-text-manipulation/

**Excel Data & Text Manipulation - Intermediate Users:
https://excelprimed.com/courses/excel-intermediate-data-text-manipulation/

Видео Excel LOOKUP Function канала Excel Primed