MrBorders,

We're both using 2003 - Do you have a 2003 version saved by chance? In the meantime, try the above formula create a sample worksheet to test it out.

Column A
11368
14228

Column B
Corona // should be returned from column D based on column A matching column C
Amherst // should be returned from column D based on column A matching column C

Column C
14228
11368

Column D
Amherst
Corona