Complex formula to create seat assignment

[didierkassas]

Hello everyone,

i am looking to create some formulas that will allow me to do the following:


See if a number is present in an array
if the number is present, where it is located according to a specific table.

the goal is to be able to assign seats for an event that i am doing and make sure that all are seated

below is a picture of what my excel looks like

Floor plan here


i need to populate the following column



Seated
Row
Seat Number


Any help is welcome

Thank you