How to use Excel’s VLOOKUP MATCH functions to find values based on row and column lookups. The MATCH function offers several ways to create dynamic lookups, which can be easily copied across a range of cells in a worksheet.
Look up values in a table, using Excel’s VLOOKUP with the CONCATENATE function to combine values in multiple cells for the lookup. For example, convert a long format data table to a wide format data table.
Excel’s IFERROR function traps errors that could be returned from a formula or calculation, and gives you control over what is returned instead of an error message.