I'm having a problem using the LOOKUP function in excel. Its real
simple, its suppose to look up a letter grade, and return the GPA for
it. When it looks up C, it should return 2.0, but it returns 2.7!


[image: http://i2.photobucket.com/albums/y36/no-sweat/help.jpg]
*note - D5 is where the lookup function is



Code:
--------------------
=VLOOKUP(D3,A1:B11,2)
--------------------
that doesn't work either :(

any ideas?

thanks.


--
no-sweat
------------------------------------------------------------------------
no-sweat's Profile: http://www.excelforum.com/member.php...o&userid=26878
View this thread: http://www.excelforum.com/showthread...hreadid=401133