If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Getting a value by comparing 2 columns
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! |
#2
|
|||
|
|||
Getting a value by comparing 2 columns
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 "NeedExcelHelp" wrote: 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! |
Thread Tools | |
Display Modes | |
|
|