|
using vlookup and hyperlink
I am using VLookup in column D that replicates a number from column B.
This works fine. What I would like to do is type the number into B and have it populate D with not just the number from B, but provide a hyperlink in D. If I put the hyperlink into my lookup table, the link does not show up in D. I assume that I can use both vlookup and hyperlink, but I am not sure how to use both for the same cell. |
using vlookup and hyperlink
With search number in B1 and the lookup array C:D try the below. Adjust to suit
=HYPERLINK(VLOOKUP(B1,C:D,2,FALSE)) If this post helps click Yes --------------- Jacob Skaria "MJ" wrote: I am using VLookup in column D that replicates a number from column B. This works fine. What I would like to do is type the number into B and have it populate D with not just the number from B, but provide a hyperlink in D. If I put the hyperlink into my lookup table, the link does not show up in D. I assume that I can use both vlookup and hyperlink, but I am not sure how to use both for the same cell. |
using vlookup and hyperlink
I enter a number like 55053 in to cell b6, in d6 a get the number 55053.
Here is the formula in cell d6 =IF(B60,VLOOKUP(B6,Parts!A2:$D15035,4,FALSE),"") In the Parts worksheet, I have a hyperlink to a site for a PDF file to download. I am still not sure how to get the hyperlink for number 55053 in the lookup to pull through with the hyperlink, the link is not there and the number 55053 shows up. What I need to do is enter 55053 into b6 and d6 fill with the hyperlinked number 55053 from d6. If this is not clear let me know what I need to provide to make it clear. "Jacob Skaria" wrote: With search number in B1 and the lookup array C:D try the below. Adjust to suit =HYPERLINK(VLOOKUP(B1,C:D,2,FALSE)) If this post helps click Yes --------------- Jacob Skaria "MJ" wrote: I am using VLookup in column D that replicates a number from column B. This works fine. What I would like to do is type the number into B and have it populate D with not just the number from B, but provide a hyperlink in D. If I put the hyperlink into my lookup table, the link does not show up in D. I assume that I can use both vlookup and hyperlink, but I am not sure how to use both for the same cell. |
using vlookup and hyperlink
If you have the PDF file name in Column D of 'Parts' then the below would work
=IF(B60,HYPERLINK(VLOOKUP(B6,Parts!A2:$D15035,4,F ALSE),B6),"") If this post helps click Yes --------------- Jacob Skaria "MJ" wrote: I enter a number like 55053 in to cell b6, in d6 a get the number 55053. Here is the formula in cell d6 =IF(B60,VLOOKUP(B6,Parts!A2:$D15035,4,FALSE),"") In the Parts worksheet, I have a hyperlink to a site for a PDF file to download. I am still not sure how to get the hyperlink for number 55053 in the lookup to pull through with the hyperlink, the link is not there and the number 55053 shows up. What I need to do is enter 55053 into b6 and d6 fill with the hyperlinked number 55053 from d6. If this is not clear let me know what I need to provide to make it clear. "Jacob Skaria" wrote: With search number in B1 and the lookup array C:D try the below. Adjust to suit =HYPERLINK(VLOOKUP(B1,C:D,2,FALSE)) If this post helps click Yes --------------- Jacob Skaria "MJ" wrote: I am using VLookup in column D that replicates a number from column B. This works fine. What I would like to do is type the number into B and have it populate D with not just the number from B, but provide a hyperlink in D. If I put the hyperlink into my lookup table, the link does not show up in D. I assume that I can use both vlookup and hyperlink, but I am not sure how to use both for the same cell. |
using vlookup and hyperlink
Getting closer!
There is a hyperlink, but when I click on it I get, "Cannot open the specified file". If I go to the page with the link I can click on it and it will open the link. What do you think I am doing wrong? "Jacob Skaria" wrote: If you have the PDF file name in Column D of 'Parts' then the below would work =IF(B60,HYPERLINK(VLOOKUP(B6,Parts!A2:$D15035,4,F ALSE),B6),"") If this post helps click Yes --------------- Jacob Skaria "MJ" wrote: I enter a number like 55053 in to cell b6, in d6 a get the number 55053. Here is the formula in cell d6 =IF(B60,VLOOKUP(B6,Parts!A2:$D15035,4,FALSE),"") In the Parts worksheet, I have a hyperlink to a site for a PDF file to download. I am still not sure how to get the hyperlink for number 55053 in the lookup to pull through with the hyperlink, the link is not there and the number 55053 shows up. What I need to do is enter 55053 into b6 and d6 fill with the hyperlinked number 55053 from d6. If this is not clear let me know what I need to provide to make it clear. "Jacob Skaria" wrote: With search number in B1 and the lookup array C:D try the below. Adjust to suit =HYPERLINK(VLOOKUP(B1,C:D,2,FALSE)) If this post helps click Yes --------------- Jacob Skaria "MJ" wrote: I am using VLookup in column D that replicates a number from column B. This works fine. What I would like to do is type the number into B and have it populate D with not just the number from B, but provide a hyperlink in D. If I put the hyperlink into my lookup table, the link does not show up in D. I assume that I can use both vlookup and hyperlink, but I am not sure how to use both for the same cell. |
using vlookup and hyperlink
Try this
(all in one line) =IF(B60,HYPERLINK(INDIRECT(CELL("address",INDEX(S heet2!D2:$D15035,MATCH(B6,Sheet2!A2:$A15035,0)))), B6),"") If this post helps click Yes --------------- Jacob Skaria "MJ" wrote: Getting closer! There is a hyperlink, but when I click on it I get, "Cannot open the specified file". If I go to the page with the link I can click on it and it will open the link. What do you think I am doing wrong? "Jacob Skaria" wrote: If you have the PDF file name in Column D of 'Parts' then the below would work =IF(B60,HYPERLINK(VLOOKUP(B6,Parts!A2:$D15035,4,F ALSE),B6),"") If this post helps click Yes --------------- Jacob Skaria "MJ" wrote: I enter a number like 55053 in to cell b6, in d6 a get the number 55053. Here is the formula in cell d6 =IF(B60,VLOOKUP(B6,Parts!A2:$D15035,4,FALSE),"") In the Parts worksheet, I have a hyperlink to a site for a PDF file to download. I am still not sure how to get the hyperlink for number 55053 in the lookup to pull through with the hyperlink, the link is not there and the number 55053 shows up. What I need to do is enter 55053 into b6 and d6 fill with the hyperlinked number 55053 from d6. If this is not clear let me know what I need to provide to make it clear. "Jacob Skaria" wrote: With search number in B1 and the lookup array C:D try the below. Adjust to suit =HYPERLINK(VLOOKUP(B1,C:D,2,FALSE)) If this post helps click Yes --------------- Jacob Skaria "MJ" wrote: I am using VLookup in column D that replicates a number from column B. This works fine. What I would like to do is type the number into B and have it populate D with not just the number from B, but provide a hyperlink in D. If I put the hyperlink into my lookup table, the link does not show up in D. I assume that I can use both vlookup and hyperlink, but I am not sure how to use both for the same cell. |
using vlookup and hyperlink
Same thinhs happens with this change. I had to change the "sheet2 to Parts,
for it to work, but no link connection. "Jacob Skaria" wrote: Try this (all in one line) =IF(B60,HYPERLINK(INDIRECT(CELL("address",INDEX(S heet2!D2:$D15035,MATCH(B6,Sheet2!A2:$A15035,0)))), B6),"") If this post helps click Yes --------------- Jacob Skaria "MJ" wrote: Getting closer! There is a hyperlink, but when I click on it I get, "Cannot open the specified file". If I go to the page with the link I can click on it and it will open the link. What do you think I am doing wrong? "Jacob Skaria" wrote: If you have the PDF file name in Column D of 'Parts' then the below would work =IF(B60,HYPERLINK(VLOOKUP(B6,Parts!A2:$D15035,4,F ALSE),B6),"") If this post helps click Yes --------------- Jacob Skaria "MJ" wrote: I enter a number like 55053 in to cell b6, in d6 a get the number 55053. Here is the formula in cell d6 =IF(B60,VLOOKUP(B6,Parts!A2:$D15035,4,FALSE),"") In the Parts worksheet, I have a hyperlink to a site for a PDF file to download. I am still not sure how to get the hyperlink for number 55053 in the lookup to pull through with the hyperlink, the link is not there and the number 55053 shows up. What I need to do is enter 55053 into b6 and d6 fill with the hyperlinked number 55053 from d6. If this is not clear let me know what I need to provide to make it clear. "Jacob Skaria" wrote: With search number in B1 and the lookup array C:D try the below. Adjust to suit =HYPERLINK(VLOOKUP(B1,C:D,2,FALSE)) If this post helps click Yes --------------- Jacob Skaria "MJ" wrote: I am using VLookup in column D that replicates a number from column B. This works fine. What I would like to do is type the number into B and have it populate D with not just the number from B, but provide a hyperlink in D. If I put the hyperlink into my lookup table, the link does not show up in D. I assume that I can use both vlookup and hyperlink, but I am not sure how to use both for the same cell. |
| All times are GMT +1. The time now is 10:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com