Check out VLOOKUP. You can find some examples he

http://www.contextures.com/xlFunctions02.html

HTH
Jason
Atlanta, GA

-----Original Message-----
the first page of my worksheet contains a list of people,
table numbers and
meals selected
page two contains the table numbers.
i want to be able to type the table number on page one
and have the tables
automatically fill the people on page two
is there a way to do it without utilizing the pivot table?
.