if your table is in cells a1:b12 then

=vlookup(cell with mark,a1:b12,2,true) will give you the corresponding
gpa

cell with mark is whatver cell has the mark (ie 66) in it


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=490572