VLOOKUP or INDEX
 

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

VLOOKUP or INDEX
 

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 ?

VLOOKUP or INDEX
 

It is not common to try and get "fuzzy matches" on unsorted data. That's
asking for problems.

Sorted data allows VLOOKUP() or LOOKUP() to do fuzzy matches. VLOOKUP()s
last parameter must be set to TRUE for that to occur:

=VLOOKUP(A1, B1:C100, 2, TRUE)

LOOKUP() is by definition a fuzzy match function, sorting is required:

=LOOKUP(A1, B1:B100, C1:C100)

The MATCH() part of an INDEX/MATCH formula can also use the TRUE parameter
to employ fuzzy matches, but only on sorted data.

--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"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 ?