Hi,
look into Debra web has lots of samples and explanations

http://www.contextures.com/xlFunctions03.html

if this helps please click yes thanks

"Ragai" wrote:

What function I can use to have an approximate mach with out sorting the data
in original sheet , is it VLOOKUP or INDEX ?