Lookup Value based off Data Validation List / Populate Form

Originally Posted by oldchippy

Hi,

In D44

=VLOOKUP($A$9,TOTALS!$A$2:$H$25,2,FALSE)

D45

=VLOOKUP($A$9,TOTALS!$A$2:$H$25,3,FALSE)

D46

=VLOOKUP($A$9,TOTALS!$A$2:$H$25,4,FALSE)

D47

=VLOOKUP($A$9,TOTALS!$A$2:$H$25,5,FALSE)

D48

=VLOOKUP($A$9,TOTALS!$A$2:$H$25,6,FALSE)

Format the cells to 2 decimal places

I was hoping that I could do it somewhat more automatically. Ideally, I would like her (the teacher) to select the name and then print it essentially.