Posted by: tonyteaching | February 15, 2009

Ms. Excel 2007: to change Mark to Grade using VLOOKUP

To change Total Mark to Grade is simple just using formula VLOOKUP

= VLOOKUP (cell’s position of the mark that we want to change, Range of Reference between Mark and Grade, What column of the Reference that will be printed or in this case which contains the Grade)

for example:

= VLOOKUP (C2, $H$15:$I$20,2)

it is said “on this cell print value based on value on cell C2 that will be converted using reference table in range $H$15:$I$20 and the printed value is based on the value of the 2nd column”


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: