i need an excel formula that returns a hyperlink according to my entry?

Question

I want to hyperlink items in an excel sheet to their web page
for example: I have item number 12345 and its webpage is www.example.com/item=12345
So what I need is a formula that when i enter 12345 it should automatically create a hyperlink to that web page

Answer 1

If 12345 is in cell A1, you but this in B1, all one line



=HYPERLINK

("http://www.example.com/item="&A1)

Answer 2

It isn't exactly clear how many hyperlinks that you have but I suggest that you make up a vlookup table that lists the hyperlinks with the identification numbers that you want to use to the left of the hyperlinks. Sort the table in order of the number ID's.



Then use this formula (assuming ID to be entered in A1)



=HYPERLINK(VLOOKUP(A1,J1:K100,2))

Answer 3

=hyperlink(concatenate("www.example.com/ item=", ),"text you want to display")