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?

--
Biff
Microsoft Excel MVP


"hemusta" wrote in message
...
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

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" wrote:

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?

--
Biff
Microsoft Excel MVP


"hemusta" wrote in message
...
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

Maybe I misunderstood what you meant.

See if this helps:

http://contextures.com/xlFunctions02.html

--
Biff
Microsoft Excel MVP


"hemusta" wrote in message
...
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" wrote:

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?

--
Biff
Microsoft Excel MVP


"hemusta" wrote in message
...
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