If stmt - go to

[MM]

I would like to create an 'if' statement which includes
the condition if the statement is true, then 'go to' a
new location.

Is this possible???

 

[Dave Peterson]

How about a worksheet function:

=IF(A1="asdf",HYPERLINK("#"&CELL("address",'sheet 1'!A4),"go1"),
HYPERLINK("#"&CELL("address",'sheet 2'!C9),"go2"))
(One cell)

(I used two sheet names with spaces--just to show the apostrophes.)

You may want to modify the cell's style to be hyperlink. (Format|Cells|Style)