Yes, i use VlookUp, but my version is not English so i couldn't translate it
correctly.
It is operating well if i choose false or 0 to get exact match, but i would
like to search for not only exact matches.
Is it possible too?

"robertdeniro" wrote:


You didn't specify, but it seems like you're using VLookUp, are you?
VLookUp should have the last optional argument -'range_lookup'- set to
0 to do an exact match.


--
robertdeniro
------------------------------------------------------------------------
robertdeniro's Profile: http://www.excelforum.com/member.php...o&userid=14173
View this thread: http://www.excelforum.com/showthread...hreadid=396097