This article explains how to use the LOOKUP function in any version of Excel, including Excel 2019 and Microsoft 365.
How to use the LOOKUP function in Excel
The LOOKUP function in Excel is used to look up information in a row or column. It looks for a value at the same position in the row or column as the starting value, so it is very useful when working with structured tables where all the rows and columns contain similar data.
There are two ways to write a LOOKUP formula in Excel depending on your needs. One form is called vector and the other is array.
There are two ways to use the SEARCH function:
