Taking a simple extension
to the assumed set-up in Sheet1
where "Meal" is placed in col C, i.e.:

Names Table# Meal
Name1 2 Meal1
Name2 3 Meal2
Name3 4 Meal3
etc

Make a concatenated field in col D
to join the Name to the Meal

Put in D2: =A2&"-"&C2
Copy down to D10

In Sheet2
-------------
Just replace the formula in A2 by:

=IF(ISERROR(MATCH(SMALL(Sheet1!E$2:E$10,ROWS($A$1: A1)),Sheet1!E$2:E$10,0)),"
",INDEX(Sheet1!$D$2:$D$10,MATCH(SMALL(Sheet1!E$2:E $10,ROWS($A$1:A1)),Sheet1!
E$2:E$10,0)))

Copy across and fill down as before

The amendment made was to the ...INDEX(...) part,
to point now to col D instead of col A (in Sheet1), viz.:

.... INDEX(Sheet1!$A$2:$A$10

changed to:

.....INDEX(Sheet1!$D$2:$D$10

The above will return:the concat "Name-Meal"s
under each table number
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"cds" wrote in message
...
thanks. that works for the names, however i also need to extrat the 'meal'
next to the person. i tried the lookup but since the data is not sorted it
doesn't work. any suggestions?