Is this a VLOOKUP that you are doing? If so you need to use
'=VLOOKUP(ref,range,FALSE).


--
Hodge
------------------------------------------------------------------------
Hodge's Profile: http://www.excelforum.com/member.php...o&userid=16342
View this thread: http://www.excelforum.com/showthread...hreadid=277304