Hello,
I'm getting married this weekend and we have been working on a spreadsheet for assigning guests to tables. Unfortunately, on my future wife's side of the family, there are a lot of rules about who can sit at who's table. I have been tinkering for the past few day on trying to make an easy tracking system for the tables. I know the rules about who can sit where, I'm just looking for a "live" update of who is sitting where after I assign them a table number.
My data is broken into
Name Table # Her Mother Table 1 Her Father Table 3 Her Step-Father Table 1 Her Grandmother Table 3 My Mother Table 2
I would like to keep using this format to place table assignments since I have other columns for meal choices, gifts, etc...
I would like to be able to have a table that would add the name of the person when a table number is assigned.
Example of what I'm looking for
Table 1 Table 2 Table 3 Table etc... Her Mother My Mother Her Father Her Step-Father Her Grandmother
I've been trying to figure out a formula using vlookup and if functions to automatically place anyone who has Table 1 in Column A, Table 2 in Column B, Table 3 in Column C, etc..., but it has not been going well.
Any ideas?
Thank you
Bookmarks