# Seating chart - table plans populate with names from other cells

1. ## 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!

2. ## Re: Seating chart - table plans populate with names from other cells

see attached file.
Formula used:

HTML Code:
``=IFERROR(INDEX(\$A\$1:\$A\$15,SMALL(IF(\$B\$1:\$B\$15=D\$1,ROW(\$A\$1:\$A\$15),""),ROW(1:1))),"")``
It's an array formula, so enter with CTRL+SHFT+ENT.

3. ## Re: Seating chart - table plans populate with names from other cells

Originally Posted by modytrane
see attached file.
Formula used:

HTML Code:
``=IFERROR(INDEX(\$A\$1:\$A\$15,SMALL(IF(\$B\$1:\$B\$15=D\$1,ROW(\$A\$1:\$A\$15),""),ROW(1:1))),"")``
It's an array formula, so enter with CTRL+SHFT+ENT.
this looks great. thank you!

4. ## Re: Seating chart - table plans populate with names from other cells

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

5. ## Re: Seating chart - table plans populate with names from other cells

Just marked as solved, sorry!

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1