Sort With Match Function??

  • Thread starter Thread starter GBL
  • Start date Start date
G

GBL

Hi:
Question concerning MATCH function:
=MATCH(WhatToLookFor,WhereToLook,TypeOfMatch) where TypeOfMatch may be 0
(exact), 1(exact or next lowest) or -1 (exact or next highest).
:
My reference for the match function stipulates that the list of values
being examined must be sorted for it to work properly. I have had NO
erratic results with NOT sorting. Can anyone shed more light on this
topic??
 
Hi

I've had a quick look at the help article on MATCH and it doesn't mention
that the array must be sorted. (XL2K)
 
It has to be sorted if the match type is either 1 (ascending order) or -1
(descending order)
exact match does not require any sorting
 
Hi:
Thank you for your response!!

Peo Sjoblom said:
It has to be sorted if the match type is either 1 (ascending order) or -1
(descending order)
exact match does not require any sorting

--

Regards,

Peo Sjoblom
Click to expand...
 
Back
Top