How to use the LOOKUP function in Excel to search in a single row or column and find a value from the same position in a second row or column.

This Excel tutorial explains how to use the Excel LOOKUP function with syntax and examples. The Microsoft Excel LOOKUP function returns a value from a range (one row or one column) or from an …

Mar 14, 2025 · The Excel LOOKUP function performs an approximate match lookup in a one-column or one-row range, and returns the corresponding value from another one-column or one-row range.

Jun 14, 2024 · Here’s an overview of the functions and formulas for different types of lookups in Excel. What Is a Lookup in Excel? A lookup means searching for a specific value within a row or a column …

Dec 1, 2025 · The tutorial explains the basics of Lookup in Excel, shows the strengths and weaknesses of Excel Lookup functions and provides a number of lookup examples.

Learn how to use Excel’s LOOKUP Function to search one-row or one-column ranges and return matching values using vector or array form.

The LOOKUP function finds a value in a single row or column and matches it with a value in the same position in a different row or column. The following is an example of LOOKUP formula syntax:

It's actually quite easy to do with a lookup function. The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH,  are some of the most useful functions in Excel.

Oct 28, 2025 · This look-up tool is a searchable database that allows you to look up a provider by National Provider Identifier (NPI), or by name and location. The look-up tool will return information on …

Locate a federal court case by using the Public Access to Court Electronic Records (PACER) or by visiting the Clerk’s Office of the courthouse where the case was filed.