Problem with IFS (or multiple IF)

Hi all,
Sometimes I'm having troubles with IF (and sometimes don't), so I would love to seek for an enlightenment here (file attached).
There are 4 criteria. Criteria no. 1 and 2 work well, but not with criteria no. 3-4. It seems that the formula only works for up to 2 conditions.
Anybody ever had the same/similar case?
Thank you.

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Hi, Ali. Thank you for the information. I've attached the sample file. Thank you.

Try this:

=IFERROR(IFS(I8="","",
AND(I8="IO",IFERROR(MATCH(K8,XX_Account,0),0)>0),"Clear",
AND(I8="BT",IFERROR(MATCH(K8,YY_Account,0),0)>0),"Clear",
AND(I8="JP",IFERROR(MATCH(K8,XX_Account,0),0)>0,IFERROR(MATCH(K9,ZZ_Account,0),0)>0),"Clear"),
"Error")

Please look at the attachment and copy the formula from there for your locale.

It works! Thank you for your help!

Glad to have helped.