Help with looking up test score on another sheet

[kimberly13]

I am making a Physical Fitness Test scoring workbook book for my Young Marine Program, but I am haing problems with the "lookup" part of it.

Each Child have thier own sheet with the infor across the top

Name - Age - #of sit up - Score - # of Push ups - Score - etc . . . .

On another sheet I have the scores - which you find by cross referencing age and the going down to the number of sit ups or other event.

I have tried several "lookup" type formulas with no luck.

I then have the Scores charted so the kids can see how they improve with each Fitness test.

any suggestion?????

 

[kimberly13]

Re: NOT RESOLVEd!! looking up test score on another sheet

[quote/}$A$13:$F$17 is the lookup table which you need to lock when you copy the VLOOKUP formula to other cells. The same holds for $A$12:$F$12 which is a lookup vector.[/quote]

Ok, now I really feel dumb. How and why do you "lock" the lookup table???

Sorry for so many questions

 

[Aladin Akyurek]

Re: NOT RESOLVEd!! looking up test score on another sheet

Suppose you have different names in A3:A5. Also a lookup table in E2:F100 with in E2:E100 names and F2:F100 salaries associated with those names.

If I want to know the salaries associated with each name in A3:A5, I can enter the following formula in B3 and copy down:

=VLOOKUP(A3,$E$2:$F$100,2,0) [ 0 means False ]

If you don't lock the table, the address of the table will change when you copy down the formula, something that you don't want to happen.

 

[kimberly13]

So the $ sign before the letter and the number lock it ($A$12:$A$22)

Right???

You have been wonderful!!! Sorry for the silly questions, I promise that I am keeping notes!