using vlookup and hyperlink

[MJ]

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.

 

[Jacob Skaria]

With search number in B1 and the lookup array C try the below. Adjust to suit

=HYPERLINK(VLOOKUP(B1,C,2,FALSE))

If this post helps click Yes

 

[MJ]

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(B6>0,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]

If you have the PDF file name in Column D of 'Parts' then the below would work

=IF(B6>0,HYPERLINK(VLOOKUP(B6,Parts!A2:$D15035,4,FALSE),B6),"")

If this post helps click Yes

 

[MJ]

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]

Try this

(all in one line)
=IF(B6>0,HYPERLINK(INDIRECT(CELL("address",INDEX(Sheet2!D2:$D15035,MATCH(B6,Sheet2!A2:$A15035,0)))),B6),"")

If this post helps click Yes

 

[MJ]

Same thinhs happens with this change. I had to change the "sheet2 to Parts,
for it to work, but no link connection.