I have a V-Lookup that contains email addresses. But when it transfers over
to the other sheet, the link does not work. Is that possible to make happen?
I have a V-Lookup that contains email addresses. But when it transfers over
to the other sheet, the link does not work. Is that possible to make happen?
it will work, but you will probably need to change some of the references.
if your table is staying on the original sheet (Sheet1) and your current
vlookup looks something like
=vlookup(A1, B1:C5,2)
on a different sheet but using A1 on the second sheet the new equaiton would
look like
=vlookup(A1, Shet1!B1:C5,2)
"John" wrote:
> I have a V-Lookup that contains email addresses. But when it transfers over
> to the other sheet, the link does not work. Is that possible to make happen?
Actually all the information carries over, but when the email link shows, it
shows in blue and underlined, but you can not click on it to send the email.
"bj" wrote:
> it will work, but you will probably need to change some of the references.
> if your table is staying on the original sheet (Sheet1) and your current
> vlookup looks something like
> =vlookup(A1, B1:C5,2)
> on a different sheet but using A1 on the second sheet the new equaiton would
> look like
> =vlookup(A1, Shet1!B1:C5,2)
>
> "John" wrote:
>
> > I have a V-Lookup that contains email addresses. But when it transfers over
> > to the other sheet, the link does not work. Is that possible to make happen?
Actually all the information carries over, but when the email link shows, it
shows in blue and underlined, but you can not click on it to send the email.
"bj" wrote:
> it will work, but you will probably need to change some of the references.
> if your table is staying on the original sheet (Sheet1) and your current
> vlookup looks something like
> =vlookup(A1, B1:C5,2)
> on a different sheet but using A1 on the second sheet the new equaiton would
> look like
> =vlookup(A1, Shet1!B1:C5,2)
>
> "John" wrote:
>
> > I have a V-Lookup that contains email addresses. But when it transfers over
> > to the other sheet, the link does not work. Is that possible to make happen?
Actually all the information carries over, but when the email link shows, it
shows in blue and underlined, but you can not click on it to send the email.
"bj" wrote:
> it will work, but you will probably need to change some of the references.
> if your table is staying on the original sheet (Sheet1) and your current
> vlookup looks something like
> =vlookup(A1, B1:C5,2)
> on a different sheet but using A1 on the second sheet the new equaiton would
> look like
> =vlookup(A1, Shet1!B1:C5,2)
>
> "John" wrote:
>
> > I have a V-Lookup that contains email addresses. But when it transfers over
> > to the other sheet, the link does not work. Is that possible to make happen?
it will work, but you will probably need to change some of the references.
if your table is staying on the original sheet (Sheet1) and your current
vlookup looks something like
=vlookup(A1, B1:C5,2)
on a different sheet but using A1 on the second sheet the new equaiton would
look like
=vlookup(A1, Shet1!B1:C5,2)
"John" wrote:
> I have a V-Lookup that contains email addresses. But when it transfers over
> to the other sheet, the link does not work. Is that possible to make happen?
it will work, but you will probably need to change some of the references.
if your table is staying on the original sheet (Sheet1) and your current
vlookup looks something like
=vlookup(A1, B1:C5,2)
on a different sheet but using A1 on the second sheet the new equaiton would
look like
=vlookup(A1, Shet1!B1:C5,2)
"John" wrote:
> I have a V-Lookup that contains email addresses. But when it transfers over
> to the other sheet, the link does not work. Is that possible to make happen?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks