Connecting Two Sheets by Cell Value
I have two sheets - one for contract info and one for billing info. I'd like to be able to click on a row (or field/cell) in one sheet and be taken to the respective customer's info in the other sheet. I don't need to do calculations or inbound or outbound links. I only need to click on Customer X contract info and be taken to Customer X billing info in the other sheet, and vice versa.
So, for instance, something like "click here to find Customer X on Sheet 2" . . .
Help Article Resources
Check out the Formula Handbook template!