I tried this and it didnt work since the table array has to be sorted in
ascending order for it to work and since the values in the column of
values being returned changes it will not do what i want it to. Thanks
for trying. Any other ideas?


--
Blade2304
------------------------------------------------------------------------
Blade2304's Profile: http://www.excelforum.com/member.php...o&userid=33492
View this thread: http://www.excelforum.com/showthread...hreadid=542369