Create a lookup table

Eg
A B
1 0 '
2 2 2 pts
3 5 5 pts
4 10 10 pts


Include a space in Cell B1 otherwise it returns a 0

If the value you want to reference is in cell d1 use
=VLOOKUP(D1,$A$1:$B$4,2)

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=544891