Formulas & functions
How a function works, with worked examples you can paste.
- INDEX and MATCH in Excel: How to Find Values FlexiblyYes. In Excel, INDEX and MATCH work together to find a value by its position: MATCH locates the requested item, and INDEX…
- INDEX and VLOOKUP in Excel: How They Work and CompareINDEX and VLOOKUP are both Excel lookup tools: VLOOKUP searches the leftmost column of a range and returns a value to its…
- VLOOKUP and HLOOKUP in Excel: Formulas and UsesIn Excel, VLOOKUP searches down the first column of a table and returns a value from a column to its right; HLOOKUP…
- Why Is HLOOKUP Used in Excel? Uses and Examples ExplainedHLOOKUP is used in Excel to find a value in the top row of a table and return a related value from…
- Excel INDEX Absolute References: When and How to Use ThemYes, an Excel INDEX formula can use absolute references, and locking its ranges is often helpful when you copy the formula. Add…
- HLOOKUP in Excel: Purpose, Examples, and LimitsHLOOKUP in Excel searches for a value across the top row of a table and returns a related value from a specified…
- VLOOKUP and HLOOKUP in Excel: Differences and ExamplesVLOOKUP searches down the first column of a table and returns a value from a column to its right; HLOOKUP searches across…
- HLOOKUP in Excel With Multiple Sheets: A Practical GuideHLOOKUP does not search multiple worksheets in a single lookup operation. To search several sheets, combine separate HLOOKUP formulas—usually with IFERROR—or use…
- HLOOKUP Match in Excel: Exact and Approximate ResultsTo match a value across the top row of a range in Excel, use HLOOKUP and set its fourth argument to FALSE…
- HLOOKUP in Excel: How Horizontal Lookups WorkHLOOKUP in Excel searches across the first row of a range for a value, then returns a value from another row in…
- HLOOKUP in Excel: Sample Formula and ExamplesFor a simple HLOOKUP sample, with years in B1:E1 and revenue in B2:E2, use =HLOOKUP(2025,B1:E2,2,FALSE); it returns the value under 2025, which…
- HLOOKUP in Excel With Multiple Criteria: A Clear GuideHLOOKUP does not accept separate criteria on its own, but you can make it work by combining the criteria into one helper…
- Excel Reverse HLOOKUP: Formulas and Better AlternativesExcel has no separate “reverse HLOOKUP” function. If you mean looking up a value in one row and returning the corresponding value…
- Excel VLOOKUP, HLOOKUP, and XLOOKUP: Key DifferencesVLOOKUP searches down the first column of a table, HLOOKUP searches across its first row, and XLOOKUP searches a chosen range and…
- Advanced Excel HLOOKUP Formula: Examples and TipsFor an advanced Excel HLOOKUP, use =HLOOKUP(F1,$A$1:$D$4,2,FALSE) when the value to find is in F1, the lookup keys are across the first…
- Combine HLOOKUP and VLOOKUP in ExcelYes. You can nest VLOOKUP inside HLOOKUP so VLOOKUP finds the row number and HLOOKUP finds the column heading; the formula can…
- XLOOKUP Multiple Criteria: Formula and ExamplesYes. In Excel for Microsoft 365 or Excel 2021 and later, XLOOKUP can match multiple criteria by multiplying the tests for an…
- XLOOKUP Excel Version: Compatibility and AvailabilityXLOOKUP is available in Microsoft 365, Excel 2021, and Excel 2024, as well as Excel for the web and supported mobile apps.…
- XLOOKUP Excel Conditional Search: Formulas and ExamplesTo use XLOOKUP for a conditional search in Excel, put the condition in its lookup array; for multiple conditions that must all…
- XLOOKUP Excel Criteria Match: Exact and Multiple CriteriaYes. XLOOKUP can match a criterion exactly by default, and it can also search with approximate or wildcard rules. For multiple criteria,…
- XLOOKUP Excel Example: Search Across Two Excel SheetsIf Orders!A2 contains a product code, and Products!A2:A100 contains product codes with prices in Products!C2:C100, enter =XLOOKUP(A2,'Products'!$A$2:$A$100,'Products'!$C$2:$C$100,"Not found") on the Orders sheet.…
- XLOOKUP Excel Column Match: Find a Column by HeaderTo match a value in an Excel column and return a value from another column, use XLOOKUP with the search column as…
- XLOOKUP in Excel: Compare Two Lists and Find MatchesYes. In Excel, XLOOKUP can compare a value in one list with another and return the matching item or a message when…
- XLOOKUP Case Sensitivity: How Excel Matches Text ValuesNo. In Excel for Microsoft 365, XLOOKUP is not case-sensitive: it treats text such as “Maple,” “MAPLE,” and “maple” as the same…
- XLOOKUP Excel Column Index: What Replaces It?XLOOKUP does not use a column index number. Instead, you give it the range or array to search and then directly give…
- XLOOKUP Between Two Sheets in Excel?Yes. To look up a value on one Excel sheet and return a related value from another, use XLOOKUP with the lookup…
- VLOOKUP in Excel: Purpose, Examples, and Limits ExplainedVLOOKUP in Excel looks for a value in the first column of a range and returns a related value from another column…
- VLOOKUP in Excel for Multiple Columns: Methods and TipsYes. In Excel for Microsoft 365, VLOOKUP can return values from multiple columns either by copying one formula across the output row…
- VLOOKUP Excel Sample: Formula and Worked ExampleWith a lookup value in E2 and a table whose IDs are in A2:A5 and prices are in C2:C5, enter =VLOOKUP(E2,$A$2:$C$5,3,FALSE) to…
- VLOOKUP Excel: Extended Uses, Examples, and LimitsVLOOKUP can do more than retrieve one value from a simple list: it can use exact or approximate matches, wildcards, multi-part lookup…