Dear Friends,

I need code for to find the record through macth command instead of
vlookup command. It is because the data is not in a sort order, and i
don't want to change the sorting order of the original data.

When the data found then select the 3rd col of the row in a textbox1.

Thanks in advance

Syed Haider Ali


--
Syed Haider Ali
------------------------------------------------------------------------
Syed Haider Ali's Profile: http://www.excelforum.com/member.php...o&userid=21994
View this thread: http://www.excelforum.com/showthread...hreadid=397469