Formulas confussed

[Si]

I wish to create a formula for a menu placecard but i get so far &
then.............
the 1st spreadsheet has the meal set in columne B (5 starters, 7 main meals
& 5 desserts) in row 2 is the list of names attending the function. the
resulting table is ticked (Wingdings 2 = P) for each persons order
what i wish to do is copy all persons meal settings into another spreadsheet
so i can print placecards with their name on the front and meal on the back
without having to copy & paste individually
I have tried the 'IF' formula but this only allows for 2 functions
HELP with this to find a solution would be greatly appreciated as I am born
again lazy and a dyslexic ficko

 

[Bob Phillips]

Maybe something like, assuming the name is in A1 on the person sheet

Starter:

=INDEX($A$3:$A$7,MATCH("P",OFFSET(A2,1,MATCH("Bill",$2:$2,0)-1,ROWS($A$3:$A$7))))

Main meal

=INDEX($A$8:$A$14,MATCH("P",OFFSET(A2,1,MATCH("Bill",$2:$2,0)-1,ROWS($A$8:$A$14))))

Dessert

=INDEX($A$15:$A$19,MATCH("P",OFFSET(A2,1,MATCH("Bill",$2:$2,0)-1,ROWS($A$15:$A$19))))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)