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
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