Index | search
Click here to view Index news from 60+ newspapers.
Bookmark or Share- Look up values with VLOOKUP, INDEX, or MATCH - Microsoft SupportUse 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 to more. Skip to main content
- XLOOKUP function - Microsoft SupportUse 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 employee ID.
- How to correct a #VALUE! error in INDEX/MATCH functionsIf you are using INDEX as an array formula along with MATCH in order to be able to retrieve a value, you will need to convert your formula into an array formula, otherwise you will see a #VALUE! error.
- How to correct a #N/A error in INDEX/MATCH functionsThe topic describes the most common reasons for "#N/A error" to appear are as a result of either the INDEXor MATCH functions. Note: If you want either the INDEX or MATCH function to return a meaningful value instead of #N/A, use the IFERROR function and then nest the INDEX and MATCH functions within that function.
- Lookup and reference functions (reference) - Microsoft SupportExcel 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.
More
