Urmm Help.

C

Chemx

Ive got a excel database with 22000 names and address of financial
brokers. Ive been giving the task to find email address for as many as
possible. I know this might be a bit of a long shot, but is there a way
of doing a mass search for there company names?. I know this is really a
excel problem, but it would be great if anyone knows anything.

Thanks
 
B

BenjieLop

Chemx said:
Ive got a excel database with 22000 names and address of financial
brokers. Ive been giving the task to find email address for as many as
possible. I know this might be a bit of a long shot, but is there a way
of doing a mass search for there company names?. I know this is really a
excel problem, but it would be great if anyone knows anything.

Thanks
Click to expand...

If your data are arranged as follows:

A1:A22000 -- company names of financial brokers
B1:B22000 -- addresses (ASSUME that these are email addresses)


In Cell C1, enter the name of the company whose email address you want
to know.

In Cell D1, enter this formula

=VLOOKUP(C1,$A$1:$B$22000,2)

I hope this is what you need.

Regards.
 
Top