If Match Function

[vishan]

Hi,


I want a formula smiler below.

=IF(MATCH(B2,D2:D20,0),"MATCH","NOT MATCHED"

But when i use it, it gives false value with '#n/a' . pls help in this.

 

[JackDanIce]

Try:

=IF(ISNUMBER(MATCH(B2,D2:D20,0)),"MATCH","NOT MATCHED")

 

[vishan]

Great it's working, thanks,
can you pls tell me difference between ISERROR or ISNUMBER

bcoz when i use ISERROR, formula give reverse ans. as first Flase value then True value??

 

[JackDanIce]

ISERROR tests if the function results in an output that is an error or is not, e.g. ISERROR(1/0) is TRUE because you cannot divide a number by 0.

ISNUMBER tests the output of a function is numerical (or not) e.g. ISNUMBER(1+1) = TRUE because the answer to 1 + 1 is a numberical value.

MATCH always gives an output of a numerical value, IF it finds a valid match for the item you are searching.

 

[vishan]

great knowledge.........thnkx sir.

 

[JackDanIce]

You're welcome