I have 2 spreadsheets. One is a database of all our dealer codes and the
state they are located in. The other is a list of all dealer codes that took
part in a promotion. I would like to add a column to the 2nd spreadsheet and
have excel look up each dealer code and insert which state they are in.