Hyperlink Issue

[Istiyak]

Namaste Team.


Plz examine the given formula and revert with the solution.


=if(a1=b1,hyperlink(a1,"Check"),hyperlink(b1,"Check"))


While i am clicking on it, it is going on a1 even the condiotion is false (Naturally when condition false it should go on b1).


Suggest what to do.?


Regards

Istiyak

 

[NARAYANK991]

Hi ,


Change your formula to :


=IF(A1=B1,HYPERLINK("#A1","Check"),HYPERLINK("#B1","Check"))


The '#' sign is required before cell addresses in the HYPERLINK function.


Narayan

 

[Istiyak]

hi Narayank991


Thank a lot dear its working fine.....its something like HTML link to go on the same page but another location..


Appriciated..


Regards

Istiyak