Lookup

  • Thread starter Thread starter hemusta
  • Start date Start date
H

hemusta

I have a question regarding lookup

I have a customer list with all the customers with their addresses.

I have another list with only the first name of the customers.

Now I want to look up the name of the customer of the second list in the
first list and print the whole address. How do I do this?

Thanks

Henk Mulder
 
This sounds impossible!

John Smith - 2220 Springer St., New Haven
Betty Rubble - 123 Rock Lane, Bedrock
John McDoofus - 666 Deadend Blvd., Phoenix

If you wanted to lookup the address of John which address should be
returned?
 
Not if you select on John McDoofus.

Maybe I should use import in Access and then export back to excel? if I do
not have access at work.
 
Back
Top