I need a formula/cell definition that can automatically refer cells once a certain number is attached to it. So: If I type "Row 1 Seat 1" in front of a person's name, that persons name will appear in a corresponding cell in a different sheet.
Solved by T. W. in 28 mins