I'd like a "If a certain cell matches this number, go to Sheet 2"

Macro required. You would put this code in whatever sheet it is that has the A1 you are talking about.

Please Login or Register  to view this content.

This assumes that there is some value on the same sheet that will cause A1 to become 1. If A1 has a formula that refers only to other sheets, then this won't work.