Could you define "performs better"?

I don't doubt you when it comes to anything technical, but I would venture a
guess that the vast majority of the respondents within these groups wouldn't
have come up with your formula if they were given a stipulation of
suggesting a procedure to return an exact match from a datalist.

If you'll notice, in my original response to the OP, I suggested the Index
and Match combination in addition toVlookup.
Does that combo also "perform less better" then the formula you suggested?

Is the performance noticable in a 100 row by 50 column datalist? ... 500 X
100?

I truly believe that the simplicity of the suggestions in a comparison to
the estimated expertise of the OP, gauged by the question itself, dictates
how complex the answer should (could ... would) be.

A complex VBA suggestion in the "New Users" group, to an OP with no apparent
knowledge of the "fill handle" or absolute or relative references comes to
mind.

True, oft times the discussion is removed from the OP, and continues among
the respondents, for their own edification and entertainment and "one
upsmanship".

Is that what this is?<bg
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------



"Aladin Akyurek" wrote in message
...

=IF(LOOKUP(LookupValue,$F$2:$F$100)=LookupValue,LO OKUP(LookupValue,$F$2:$G$1
00),"")

where F2:G100 is the lookup table, sorted on F2:F100 in ascending order,
will perform better than:

=VLOOKUP(LookupValue,$F$2:$G$100,2,0)

or


=IF(ISNA(VLOOKUP(LookupValue,$F$2:$G$100,2,0)),"", VLOOKUP(LookupValue,$F$2:$
G$100,2,0))

Ragdyer wrote:
OP is looking for an exact match Aladin, as construed in the third line
of
the OP.