I need formula help!!!!!

Hossman617

New Member
Joined
Oct 19, 2006
Messages
1
Hey,

I'm working from two large databases. One db (A) has a list e-mail addresses, the other db (B) has a list of names and e-mails.

I need to search on B using the e-mail from A and paste the name in it's proper form back on A. Is there a formula I can use to do this so I won't have to go one by one????

For ex. =if(email from A) (matches e-mail from B) (replace with name on B)

Many thanks.
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

plettieri

Well-known Member
Joined
Sep 4, 2002
Messages
1,556
Platform
  1. MacOS
Hi:

It sounds like a Vlookup formula might do the trick. Review some of the samples found in the search feature of this forum

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

plettieri
 

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
plettieri's right - VLookup() would probably be the place to start. Have a look in the wiki for a little more info on it.
 

Watch MrExcel Video

Forum statistics

Threads
1,113,810
Messages
5,544,425
Members
410,610
Latest member
renatha prado
Top