Linking to another sheet when a certain word is used

justin46491

I am trying to get 2 sheets to work together.  Meaning when I have a certain word or phrase I would like it to link to another sheet.  How ever it can only be that word or phrase or nothing else.  

 

I need help

Thank You

L_123

=if(find("Phrase",[Column2]1)>0,{link to cell in other page},"")

 

URL Posted below is help on referencing other pages

https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets