Internet Search Results 

Using IF with AND, OR, and NOT functions in Excel
In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False.

Look up values with VLOOKUP, INDEX, or MATCH - Microsoft Support
Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE) In this example, B2 is the first argument —an element of data that the function needs to work. For VLOOKUP, this first argument is the value that you want to find. This argument can be a cell reference, or a fixed value such as "smith" or 21,000.

LOOKUP function - Microsoft Support
Use LOOKUP, one of the lookup and reference functions, when you need to look in a single row or column and find a value from the same position in a second row or column. For example, let's say you know the part number for an auto part, but you don't know the price.

Open a document after a file corruption error - Microsoft Support
Open and repair a document after getting a file corruption error, and see how to prevent file corruption in the future.

How to correct a #N/A error in INDEX/MATCH functions
Replacing #N/A with your own value only identifies the error, but does not resolve it. So, it's very important, before using IFERROR, ensure that the formula is working correctly as you intend. When the MATCH function does not find the lookup value in the lookup array, it returns the #N/A error.

XLOOKUP function - Microsoft Support
Use 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.

Repair a corrupted workbook - Microsoft Support
When Microsoft Excel detects a corrupted workbook upon opening, it automatically starts File Recovery mode and attempts to repair the workbook. If File Recovery mode doesn’t start, try using this manual process to recover your workbook: Click File > Open. Click the location and folder that contains the corrupted workbook.

Find or replace text and numbers on a worksheet
Use 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. You can include wildcard characters such as question marks, tildes, and asterisks, or numbers in your search terms.

Excel specifications and limits - Microsoft Support
In Excel 2010, the maximum worksheet size is 1,048,576 rows by 16,384 columns. In this article, find all workbook, worksheet, and feature specifications and limits.

IFERROR function - Microsoft Support
You can use the IFERROR function to trap and handle errors in a formula. IFERROR returns a value you specify if a formula evaluates to an error; otherwise, it returns the result of the formula. IFERROR (value, value_if_error) The IFERROR function syntax has the following arguments: value Required. The argument that is checked for an error.

OFFSET function - Microsoft Support
This article describes the formula syntax and usage of the OFFSET function in Microsoft Excel. Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. The reference that is returned can be a single cell or a range of cells.