I have a seating chart with a cell I don't see a formula for. I can enter the seat number (ex. 12345) into the cell (B1) and it will move to and highlight the corresponding cell within the sheet which enables me to locate the seat within a room. I need to duplicate this for another workbook. What is the formula?
Bookmarks