combining data from two separate sheets

M

mmenashe

hello all

I would like to combine some data, here is what I ahve

Sheet 1
email | webpage
fdsf | AAA
aasd | BBB
rtew | DDD
yuui | EEE



Sheet 2

name | address | city | webpage
dff | 123 fe | fds | AAA
ggfd | 543 re | erw | BBB
dfsf | 34 ffd | aawe | CCC
ghh | 3424 fd | sfty | DDD
jkkl | sdfs | sgdg | EEE


of course the names, address, are just junk examples. The number of
emails and webpages in Sheet 1 outnumber those in Sheet 2, but the
primary information which I need to match belongs to sheet 2.

In a perfect world, there would be a way for me to add in the emails
from the matching webpage entries onto Sheet 2, from the domain and
corresponding pages in sheet one, so I would end up with the
following:

name | address | city | webpage | email
dff | 123 fe | fds | AAA | fdsf
ggfd | 543 re | erw | BBB | aasd
dfsf | 34 ffd | aawe | CCC |
ghh | 3424 fd | sfty | DDD | rtew
jkkl | sdfs | sgdg | EEE | yuui

thanks for any possible help on this issue
 
Top