If I enter in cell A3 -- 2
In F3:G6:
1.00 asd
2.00 sdf
3.00 dfg
4.00 fgh

Finally, into C3 -- =IF(ISNA(MATCH(A3,F3:G6,0)),"Not matched","Matched")

C3 returns Not matched;
If I change C3 to -- =IF(ISNA(MATCH(A3,F3:F6,0)),"Not matched","Matched")
C3 returns Matched;

In the first case my lookup array is 2 columns, the second 1 column. Is this
why the difference? Looks like the Match() functions performs better/cleaner
if only a single-column array is referenced versus a multicolumn reference.
Am I getting it right or what?
TIA,
Jim


"Vivaciousmohan" wrote:

Try this..

=IF(ISNA(MATCH(WhatToLookFor,WhereToLook,0)),"Not matched","Matched")

"deepak bsg" wrote:

Hello Every body
I require the match result in MATCH FUNCTION as "matched" (if
the two things matched) or "not matched" ( if it is not so). Please help me
in this regard.