Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.| 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
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