Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
58
Views
Topic starter
Hi, I want to create a conditional ifs formula: if the text in a particular cell changes, the hyperllink to another sheet in the program should change accordingly.
For instance, the changeable text is in cell E14.
My formula is:
=ifs((E14="abc",hyperlink("#'abc!',"NEXT"),(E14="mno",hyperlink("#'mno!',"NEXT"),(E14="pqr",hyperlink("#'pqr!',"NEXT"))
unfortunately, this formula is not working - what am I doing wrong?
Posted : 01/02/2019 7:43 am
Hi Gayatri,
Try this:
=HYPERLINK(IFS(E14="ABC","#'abc!'",E14="mno","#'mno!'",E14="pqr","#'pqr!'"),"NEXT")
Mynda
Posted : 02/02/2019 3:17 am
Topic starter
Thanks, this worked!
Posted : 03/02/2019 7:25 am
