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
How to use the SUMIF function in Excel to add the values in a range that meet criteria that you specify.| support.microsoft.com
The IFS function checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IFS will allow you to include up to 127 pairs of conditions (the test if something is True and the result if something is true). IFS can take the place of multiple nested IF statements.| support.microsoft.com
Formulas can sometimes result in error values in addition to returning unintended results. Learn about best practices to avoid those problems.| support.microsoft.com
A complete list of all Excel functions in alphabetical order.| support.microsoft.com
How to use the MATCH function in Excel to search for a specified item in a range of cells, returning the relative position of that item in the range.| support.microsoft.com
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