You can:

1) Use vlookup

2) Use if:

=IF(A2=8,228,IF(A2=10,182.4,IF(A2=12,152,IF(A2=16, 114,IF(A2=20,91.2,IF(A2=24,76,"Out
of Range"))))))

3) Use lookup:

=LOOKUP(A2, {8,10,12,16,20,24;228,182.4,152,114,91.2,76})


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=556149