Thank you. I used that formula with but had to put in a larger number range lookup. So, =VLOOKUP(F1,Sheet2!A:B,2,55)

One follow up. I have some zip codes as just 5 digits and the reference in worksheet 2 has all suffixes too. How do I Just reference the 1st 5 digits of the zip codes in column A on worksheet 2?