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