Hello,

I am working with a seating chart for a banquet and having issues returning the table # once a person has been assigned. Column A are the attendees, column B is their numerical ID used to assign them a seat in Table 1, column C shows the status of their table assignment. I need the table number to be returned to column E or built into the return in column C if possible.

Also, is there an easy formula I can add to Table 1 and Table 2 to show if someone is placed on two tables by accident? If a repeat name is used, can the cells turn a different color for a quick visual?

Thanks in advance!!

Sample Work Book.xlsx