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