Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas confussed
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulas confussed
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("Bil l",$2:$2,0)-1,ROWS($A$8:$A$14)))) Dessert =INDEX($A$15:$A$19,MATCH("P",OFFSET(A2,1,MATCH("Bi ll",$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) "Si" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |