Find One | search
Click here to view Find One 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.
- LOOKUP function - Microsoft SupportHow 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.
- 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.
- Look up values in a list of data - Microsoft SupportLook 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 OFFSET functions to find related data in rows and columns in Excel.
- Find or replace text and numbers on a worksheetUse the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can replace it with something else.
More
