Thanks. I have been trying the vlookup with no success! What I need i
an if function that says if the value is 1.49 and <1.51 it gives 1/2
if the value = 5 it returns 5/1 etc...

Thank

--
phil200
-----------------------------------------------------------------------
phil2006's Profile: http://www.excelforum.com/member.php...fo&userid=3509
View this thread: http://www.excelforum.com/showthread.php?threadid=55877