Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
Use VLOOKUP, HLOOKUP, and other functions like INDEX and MATCH to search for and find data based on values you enter. This article gives you a quick VLOOKUP refresher, then links …
Use Excel built-in functions to find data in a table or a range of ...
This step-by-step article describes how to find data in a table (or range of cells) by using various built-in functions in Microsoft Excel. You can use different formulas to get the same result.
LOOKUP function - Microsoft Support
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.
VLOOKUP function - Microsoft Support
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.
Look up values in a list of data in Excel - Microsoft Support
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. Use the VLOOKUP, HLOOKUP, INDEX, MATCH, and …
XLOOKUP function - Microsoft Support
Use the XLOOKUP function to find things in a table or 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 …
Lookups in Power Pivot Formulas - Microsoft Support
One of the most powerful features in Power Pivot is the ability to create relationships between tables and then use the related tables to lookup or filter related data. You retrieve related …
Use the table_array argument in a lookup function
The table_array argument is always the second argument in a VLOOKUP or HLOOKUP function (the first is the value you're trying to find), and the functions won't work without it.
HLOOKUP function - Microsoft Support
How to use the HLOOKUP function in Excel to locate specific data from a row in a table.
LOOKUP 函數 - Microsoft 支援服務
如何在 Excel 中使用 LOOKUP 函數來搜尋單一列或單欄，以及在第二列或第二欄中尋找相同位置的值。