Hyperlink(Vlookup) not pulling original website as listed from source data - Troubleshooting

[mjaeger1]

Hi All,

I am trying to use a hyperlink + vlookup formula to pull website from source data.

I have the formula correct, and the source website is also correct, however, when it is used in the destination with vlookup, it links to an sharefile/on my computer destination.

Does anyone know why this is happening?

 

[mackc557]

Are you willing to post your formula?

 

[mjaeger1]

Are you willing to post your formula?

Sure thing. Thanks for your help!

=HYPERLINK(VLOOKUP(P12,'Master Quote'!$A$2:$E$8000,5,FALSE))

Website im trying to pull is: https://www.leviton.com/en/docs/Leviton_Premium_Plus_Fiber_Patch_Cords.pdf

vlookup with link pulls me to: https://netorgft***-my.sharepoint.com/personal/{My Name}/Documents/Cut%20Sheet

 

[mjaeger1]

Are you willing to post your formula?

Please let me know if you require more info. Thanks @mackc557 !

 

[mackc557]

Are you willing to post what Master Quote sheet looks like? Based on what I see and like you said, nothing is wrong with the formula as far as syntax is concerned.