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

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

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