If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Enter a formula to return a result from a cell
Hi Guys,
I am using Excel 2000. Fairly new to excel formulas. I have done some basics and mostly learned on my own and have had help from this group from time to time. I have a table with predicted peak flow numbers for boys and girls. There are many rows and many columns but I'll just list 3 from each as an example. Rows are ages Columns are heights in inches. Row 8 is age 6 Row 9 is age 7 Row 10 is age 8 Column C is 44 Column D is 45 Column E is 46 We determine the predicted peak flow based on the age and height of the child. All of the predicted peak flows are entered. Column C Rows 8-10 100 115 120 Column D Rows 8-10 110 120 122 Column E Rows 8-10 122 132 143 I want to make a form for the user or something for them to enter in if the child is a boy or girl, the age and height and get the returned Peak Flow. How would I do this? The boys chart will be columns C-S and girls will be columns T-AJ Thanks, Linda |
#2
|
|||
|
|||
Enter a formula to return a result from a cell
Linda
Use VLOOKUP formulas. For more on that Function see Debra Dalgleish's site. http://www.contextures.on.ca/xlFunctions02.html Also see Debra's site for info on Data Validation lists with drop-down boxes for entering data like boy or girl and height. http://www.contextures.on.ca/xlDataVal01.html Might be useful. Gord Dibben Excel MVP On Sat, 3 Dec 2005 20:21:06 -0500, "LMB" wrote: Hi Guys, I am using Excel 2000. Fairly new to excel formulas. I have done some basics and mostly learned on my own and have had help from this group from time to time. I have a table with predicted peak flow numbers for boys and girls. There are many rows and many columns but I'll just list 3 from each as an example. Rows are ages Columns are heights in inches. Row 8 is age 6 Row 9 is age 7 Row 10 is age 8 Column C is 44 Column D is 45 Column E is 46 We determine the predicted peak flow based on the age and height of the child. All of the predicted peak flows are entered. Column C Rows 8-10 100 115 120 Column D Rows 8-10 110 120 122 Column E Rows 8-10 122 132 143 I want to make a form for the user or something for them to enter in if the child is a boy or girl, the age and height and get the returned Peak Flow. How would I do this? The boys chart will be columns C-S and girls will be columns T-AJ Thanks, Linda |
#3
|
|||
|
|||
Enter a formula to return a result from a cell
Thanks Gord. I'll take a look!
Linda "Gord Dibben" gorddibbATshawDOTca@ wrote in message ... Linda Use VLOOKUP formulas. For more on that Function see Debra Dalgleish's site. http://www.contextures.on.ca/xlFunctions02.html Also see Debra's site for info on Data Validation lists with drop-down boxes for entering data like boy or girl and height. http://www.contextures.on.ca/xlDataVal01.html Might be useful. Gord Dibben Excel MVP On Sat, 3 Dec 2005 20:21:06 -0500, "LMB" wrote: Hi Guys, I am using Excel 2000. Fairly new to excel formulas. I have done some basics and mostly learned on my own and have had help from this group from time to time. I have a table with predicted peak flow numbers for boys and girls. There are many rows and many columns but I'll just list 3 from each as an example. Rows are ages Columns are heights in inches. Row 8 is age 6 Row 9 is age 7 Row 10 is age 8 Column C is 44 Column D is 45 Column E is 46 We determine the predicted peak flow based on the age and height of the child. All of the predicted peak flows are entered. Column C Rows 8-10 100 115 120 Column D Rows 8-10 110 120 122 Column E Rows 8-10 122 132 143 I want to make a form for the user or something for them to enter in if the child is a boy or girl, the age and height and get the returned Peak Flow. How would I do this? The boys chart will be columns C-S and girls will be columns T-AJ Thanks, Linda |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel - return a picture or range rows as the result of a formula | juststarting | Worksheet Functions | 1 | July 4th, 2005 12:59 AM |
Possible Lookup Table | Karen | Worksheet Functions | 5 | June 8th, 2005 09:43 PM |
Formula to return ADDRESS of cell in range that meets criteria | Christie | Worksheet Functions | 1 | March 4th, 2005 11:13 PM |
Cell shows formula and not the result of the formula. | stumpy | Worksheet Functions | 2 | January 14th, 2005 04:44 PM |
formula help, if cell contains cell, then result | Frank Kabel | Worksheet Functions | 1 | April 14th, 2004 06:12 PM |