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 to more.| support.microsoft.com
Correct a #N/A error in Excel| support.microsoft.com
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 employee ID. With XLOOKUP, you can look in one column for a search term, and return a result from the same row in another column, regardless of which side the return column is on.| support.microsoft.com
An array formula (one that spans multiple cells) can do calculations on rows and columns of cells where you might otherwise need to use several formulas. For example, you can count the number of characters that are contained in a range of cells, sum only numbers that meet certain conditions (such as the lowest values in a range or numbers that fall between an upper and lower boundary), and sum every nth value in a range of values.| support.microsoft.com
A complete list of all Excel functions in alphabetical order.| support.microsoft.com
Learn how to use the Excel INDEX function for dynamic data retrieval and analysis. Explore examples, tips, and practical uses to improve your Excel skills.| Excel
How to use the INDEX function in Excel to return a value or reference to a value within a table or range.| support.microsoft.com
Master Excel formula for partial matches using VLOOKUP, XLOOKUP, Filter and more Examples. Includes downloadable file!| Excel