Return a value from the chart

[Bethh_CND]

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

[JeteMc]

If I understand correctly:
1. For the formula to populate column C: =IFERROR(INDEX(G$2:U$2,AGGREGATE(15,6,(COLUMN(G$2:U$2)-COLUMN(F$2))/(G$3:U$10=B2),1)),"No Table")
2. For the conditional formatting to indicate duplicate table assignments: =AND(G3<>"",COUNTIFS($G$3:$U$10,G3)>1)
Let us know if you have any questions.