Thread: MERGE LIST INFO
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Keep It Simple Stupid Keep It Simple Stupid is offline
external usenet poster
 
Posts: 45
Default MERGE LIST INFO

I have 2 lists:
Sheet 1 has the "target" Customer Numbers
Sheet 2 has ALL Customer Numbers + Addresses

If the customer is on List 1, I want to add the column for address (acquired
from list 2), but I do not want to add all the customers from List 2 to List
1. Is there a way to do this?