need help with excel function! trying to create seating chart
Posted on 2012-08-28
hello all looking to create a seating chart for a meeting we have coming up
basically i have all the users names in row B of my excel sheet. their table number for the meeting is in row I
there are 10 users to a table
in another sheet i want to be able to list the users under their appropriate table number
across the 1st row of the sheet (the top row) i have the table numbers, and below each table number i want to list all the users that are going to be seated at that table
is there a function i can use (i was thinking, vlookup or index) that would allow me to list the users under their appropriate table number, based on the value that is in row I from the sheet?