H

#### htkhim2990

comments in the given table below , but it doesn't work well.

Appreciate if anyone can enlighten me what went wrong with the

formula?

The formula issued : =Vlookup(C6,G6:H12,2)

There after I copied the formula to the rest of table, and

end result as shown in the table.

What was wrong with the formula?

Thank you

col

A B C D

Row Name Marks Grade Comments

6 Chin Ai Looi 45 E Perfect Score

7 Fandi Ahmad 55 D Perfect Score

8 Peter Brown 76 B Perfect Score

9 Tracy Ong 84 B Perfect Score

10 Jason Bond 86 A High Distinction

11 Linday Tay 90 A High Distinction

12 Ravi Gopal 92 A #N/A

13 kendra Ong 100 A+ #N/A

Row Marks Grade Comments

7 0 E Fail

8 50 D Pass

9 65 C Credit

10 75 B Distinction

11 85 A High Distinction

12 100 A+ Perfect Score

1) Use the VLOOKUP function lookup the grade

and Comments from the given table