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.

When you're comfortable with VLOOKUP, the HLOOKUP function is equally easy to use. You enter the same arguments, but it searches in rows instead of columns. Using INDEX and MATCH instead of …

Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.

Use the XLOOKUP function when you need to find things in a table or a range by row. For example, look up the price of an automotive part by the part number, or find an employee name based on their …

This article uses a sample worksheet to illustrate Excel built-in functions. Consider the example of referencing a name from column A and returning the age of that person from column C.

Excel comes with multiple Lookup and Reference functions that let you find matching values. Use this article to decide which function is best for your needs.

Look up data in Excel to find data in a list and verify that it's correct. Then, perform calculations or display results with the values returned.

VLOOKUP is one of the most popular, useful functions in Excel, but it’s hard to remember the formula if you don’t use it that often. If all you want is the syntax for VLOOKUP, here it is: To download a …

See examples of how to enter the cell ranges (the table_array argument) in VLOOKUP and HLOOKUP functions.

Worksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed …

If you're new to Excel, or even if you have some experience with it, you can walk through Excel's most common formulas in this tour. With real-world examples and helpful visuals, you'll be able to Sum, …