Sounds like you want a Vlookup, press your function button and search for it,
the wizard will help you figure it out
--
-John Northwest11
Please rate when your question is answered to help us and others know what
is helpful.


"Keep It Simple Stupid" wrote:

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?