Is there way to control the match result in the lookup formula.
Basically, there could be five results that meet the match criteria.
Is there a way I could control the number in which the lookup pull the
informaiton


--
MD2005
------------------------------------------------------------------------
MD2005's Profile: http://www.excelforum.com/member.php...o&userid=32285
View this thread: http://www.excelforum.com/showthread...hreadid=520402