Seating chart - table plans populate with names from other cells

Hi guys,

I am thinking of an idea for a google sheet to have a column (let's say A1 down) filled with wedding guest names. In column B, I will allocate a table number, between 1-20.

In Cell D (titled 'Table 1), how can I write a formula to retrieve the guest names who have (table) '1' allocated?

Thank you!

see attached file.
Formula used:

HTML Code: 

It's an array formula, so enter with CTRL+SHFT+ENT.

Originally Posted by modytrane

see attached file.
Formula used:

HTML Code: 

It's an array formula, so enter with CTRL+SHFT+ENT.

this looks great. thank you!

1. Click on the * Add Reputation if you think this helped you
2. Mark your thread as SOLVED when question is resolved

Just marked as solved, sorry!

Already added rep :-)