I need formula help!!!!!

[Hossman617]

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.

 

[plettieri]

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]

plettieri's right - VLookup() would probably be the place to start. Have a look in the wiki for a little more info on it.