Excel's VLOOKUP function searches cell arrays for data that you provide. The function often takes cell references as input, letting you easily apply the function to each cell in a range. Alternatively ...

VBA is a powerful program that enables non-programmers to create and edit macros. Learn how to enable & use VBA in Microsoft Excel.

But if you only do that once a year, you’ll probably have to research how to use the VLOOKUP function in Excel. For the third most used function in Excel (after SUM and AVERAGE), VLOOKUP is complex.