Home/ Questions/Q 14970
Next
Answered
computing
  • 2
Asked: 2021-12-17T14:06:33+00:00 In:

Using Vlookup To Copy Hyperlinks

  • 2

I am using the following formula to copy hyperlinks from one worksheet to another and when I click on the link, I am receiving an error that states it is unable to open as the internet site reports that the item you requested could not be found. However, if I go to the worksheet with the link on it, the site pulls up just fine. Please help!

Here is the formula I am using.
=HYPERLINK(VLOOKUP(A83,CAM!A:X,3,FALSE))

message edited by mensayjd

Share

    1 Answer

    1. Best Answer
      I tried your formula with 3 different links: This thread, an Amazon product page and a Google search result. All three links returned by the formula worked fine. Since I can’t replicate your problem, I can’t offer any suggestions.

      Could you share a couple of the links that are giving you trouble – assuming the target pages don’t contain personal or confidential information?

      Click Here Before Posting Data or VBA Code —> How To Post Data or Code.

      • 0