Getting a value by comparing 2 columns

[NeedExcelHelp]

Hi, I have a mailing list that I need to create but with a specific list of
customers.
Cust 1 in the example, is our current customer list. Cust 2 is the list of
mailing customers. How do I put the Final Cust Name in the column when Cust
1 and Cust 2 match?

Cust 1 Cust Name Cust 2 Final Cust Name
123 Jon Doe Landscaping 456
456 Mary Browns Excavating 963
789 Orlando Towers Inc 1296
963 ECT Lawns 1866
1296 Spring Specialty
1581 Land & Air Landscaping
1866 KF Rentals

Thanks for help!

 

[Duke Carey]

Assuming your master list is in cells A2:b50 and the first Cust2 entry is in
C2, use this in D2

=VLOOKUP(C2,$a$2:$b$50,2,0)

and copy down