Multiple Nested IF / ISNA

[cyliyu]

Hi,

Need some help. Thanks.

I have this ISNA/MATCH formula

Please Login or Register  to view this content.

I would like to add in one more ISNA/MATCH, what will be the nested IF/ISNA look like? or is there a simplfy formula for multiple ISNA/MATCH if more to be added?

[bebo021999]

Try to follow this construction:

=IF(C395="","",IFERROR(match_1,IFFERROR(match_2,IFERROR(match_3,Resuls_notmatch_3),Resuls_notmatch_2),Resuls_notmatch_1))

[cyliyu]

Thanks, Bebo021999.

I can't get it to work.

I tried the ISNA/MATCH, the results of "New" always show "Old", any help appreciated.

=IF(C395="","",IF(ISNA(MATCH(C395&"_"&D395,S1!$G$3:$G$100,0)),IF(ISNA(MATCH(C395&"_"&100,S1!$M$3:$M$100,0)),IF(ISNA(MATCH(C395&"_"&D395,S1!$S$3:$S$100,0)),"Old","NRFF"),"New"),"STELS"))

S1!$G$3:$G$100 - STELS
S1!$M$3:$M$100 - NEW
S1!$S$3:$S$S100 - NRFF
if none match - result "Old"

[bebo021999]

It is better to attach a sample.

(not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[cyliyu]

Please see attached sample file.

Coulmn F the calculation cell, and G the expected result.

[cyliyu]

Need some advice to correct the error.
Not able to get the expected result as highlighted in Yellow.

Attachment 695629

[Bo_Ry]

Please try at F12

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[bebo021999]

Try:

Please Login or Register  to view this content.

[cyliyu]

Thanks, Bo_Ry for pointed out my mistake and provide a 2nd formula that is even better. Appreciated.

[cyliyu]

Thanks to bebo021999 too.
A new formula learnt today. Appreciated.