How to create an automatic hyperlink?

[RAQUELAMIGARAKO]

I want excel to automatically create an hyperlink every time it finds a specific word on a column... so everytime the text in question appears a new hyperlink to the same destination will be automatically created... can i???

 

[AlanY]

try this, word in B1, link in C1

Excel 2012
	A	B	C
1	test1	test3	test3
2	test2
3	test3
4	test4
5	test5
6	test6
7	test7
8	test8
9	test9
10	test10
Sheet1

Cell Formulas
Range	Formula
C1	=IFERROR(HYPERLINK("#sheet1!A"&MATCH("*"&B1&"*",A:A,0),B1),"")

 

[RAQUELAMIGARAKO]

Hi thank you so much for your help, I've tried but had no luck, im very new in excel so far and i didn't quite catch the concept, ill try to explain my self better see if you can help me..
i have a clients list in column A in Sheet 1, and every time they pay me I place their names in A and the amount in B, in sheet 2 I have all the data for every client, so what i wanted is that every time i type in column A the name "juan" it makes itself an hyperlink to sheet 2 where ill be able to find Juan´s info... the trick is that the word "juan" will always be an hyperlink to the same spot on sheet 2...
hope i did it well enough, english is not my natal language so im not sure if i express my self in the best way... any way again thank you so much for your help