Lookup

[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

 

[T. Valko]

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?

 

[hemusta]

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.

 

[T. Valko]

Maybe I misunderstood what you meant.

See if this helps:

http://contextures.com/xlFunctions02.html