Hi Greg,

Welcome to ExcelFox !!

Convert the list into a table. In Excel select the range > click on Insert menu > Table > OK.

Now you can use this table across the workbook.

The formula would be:

=VLOOKUP(A2,Table1,2,0)