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