Populate Table Based On Data In Another Table

[oledsamaj]

Hello,

I am currently making an excel spread sheet for my wedding.

We want to automatically put the names of the guests in the guest list sheet in the seating plan sheet based on which table they are allocated in the guest list sheet, the tables are set using Lookup

Is there a formula we can use to sort this?

I have attached the spread sheet if anyone can help that would be amazing!

Thank you!

 

[Fluff]

Hi & welcome to MrExcel.
How about for table 0

=FILTER('Guest List'!C9:C100,('Guest List'!L9:L100=0)*('Guest List'!L9:L100<>""),"")

and for the others

=FILTER('Guest List'!C9:C100,'Guest List'!L9:L100=1,"")

 

[oledsamaj]

Thats perfect, we are most of the way there, where would I be putting this formula and then when I spread the formula around all the cells Spill error occurs.

 

[Fluff]

You put the formula in the 1st cell for each table only, do not drag it down.

 

[oledsamaj]

Brilliant!! Thank you!

 

[Fluff]

Glad to help & thanks for the feedback.