Match Clause

[#1]

Hi,

I am struggling with a match clause and am not sure of another way to get the result I am looking for.

When I do this, I get the result I am looking for:

=If (MATCH ([C_Code],'KAT 001','AACC 000','ZAM001','PLO 001'),'P CUSTOMERS')

But when I alter it to use numbers, then it doesnt work:
=If (MATCH ([S_App Number],'408600000','20000000','40500000',),'P CUSTOMERS')

Do you perhaps know what I am doing wrong?

Thanks

Yolanda

[srchilukoori]

Hi,

please post a sample data. My guess is the number format in the [S_App Number] is changed while loading in to the app.

Thanks.

[#3]

Hi Yolanda,

Looks like you have an extra comma:

=If (MATCH ([S_App Number],'408600000','20000000','40500000',),'P CUSTOMERS')

CORRECTED:

=If (MATCH ([S_App Number],'408600000','20000000','40500000'),'P CUSTOMERS')

[prabhu0505]

That means:

MATCH ([C_Code],'KAT 001','AACC 000','ZAM001','PLO 001') - has match (Match functions returns positive value).

MATCH ([S_App Number],'408600000','20000000','40500000',) - does not have a match (Match functions returns zero). Moreover I could see one extra comma before parenthesis '40500000',) pls take care.

[Qrishna]

Try

=If (MATCH ([S_App Number],'408600000','20000000','40500000'),'P CUSTOMERS')  //extra comma as prabhu stated

=If (MATCH ([S_App Number],'408600000','20000000','40500000') =1,'P CUSTOMERS')

//sometimes Match() condition in if() statement needs to be checked to return the output for the condition.

//match(') = 1 true ,match(') = 0 false - something like this