Is it possible to create a Cell that will have a Hyperlink to return Information from a MFG Website?

[hammerhead13]

Is it possible to create a Cell that will have a Hyperlink to return Information from a MFG Website? What i am looking to do is that I have a List of Computers that I want to have the ability to click a Link in a Cell that refers to a Serial Number to check HP Warranty Information on Official HP® Warranty Check for Printers, Laptops and Other Products | HP® Customer Support. I have found ways to do it with Support Pages since they have Static info in the Hyperlink. Any Help is greatly appreciated.

 

[Craggs82]

as the support pages have nice static URLs it should be possible, you need to use the =HYPERLINK function.

Assuming your serial number is in cell A1, it would be something like -

=HYPERLINK("https://support.hp.com/us-en/warrantyresult?serialNo="&A1,"Warranty info")

this would link to the status page based on that serial. (assuming i've got the URL right)

If your looking to pull the actual status from the site that's a different kettle of fish.

 

[hammerhead13]

as the support pages have nice static URLs it should be possible, you need to use the =HYPERLINK function.

Assuming your serial number is in cell A1, it would be something like -

=HYPERLINK("https://support.hp.com/us-en/warrantyresult?serialNo="&A1,"Warranty info")

this would link to the status page based on that serial. (assuming i've got the URL right)

If your looking to pull the actual status from the site that's a different kettle of fish.

Thank you for the Reply! This works for the Support pages and such but for Warranty you have to manually enter the Serial Number on the Official HP® Warranty Check for Printers, Laptops and Other Products | HP® Customer Support Page.

 

[Craggs82]

but when you manually enter it and press check it directs you to there? so we're just skipping the entry of the code.