Formula to take the cursor to a different, non adjacent cell

[bridgen]

I'm trying to find a formula that will move my cursor to a new cell.

Verbalized, I want to say: If x=1, go to cell B5, else go to cell G459

I have the "if" portion of the formula, but can't find a way to do the "go to" part.

Any ideas?

Thanks

[NBVC]

Formulas don't physically move cursors...

[bridgen]

Do you have any suggestions then?

[NBVC]

So if you enter 1 in cell A1, you want to go to B5 else G459...

Right-click the tab at the bottom and choose View Code, then paste:

Please Login or Register  to view this content.

in the editor pane.

Then back in the sheet type a number in cell A1...

adjust as you need....

You

[bridgen]

Thank you.