Adjust the sequence equation under two conditions

[Hany ali]

hello every one .. good evening , I want Your help to Modify this equation so that it works for two conditions as you see in My Screen ,Right Result In Column E
This Equation what i Used

=IF(A2="","",COUNTIF($A$2:A2,A2) & " "&IF(ISNUMBER(MATCH(A2,$G$2:$G$4,0)),CHOOSE(MATCH(A2,$G$2:$G$4,0),"Q","K","S"),""))

 

[Marcilio]

Hany ali, Good evening.

You didn't tell us your intentions with the formula.

A2 --> =IF(A2="";"";"1 "&IF(B2="Enterance Fees"; IFERROR(VLOOKUP(A2;$G$2:$I$4;3;FALSE);"");""))

Please, tell us if it worked for you.

I hope it helps.

 

[Hany ali]

THANKS ...I want to sequence continuously, not just 1
I FOUND What I want ,it must be

=IF(A8="","",COUNTIFS($A$2:A8,A8,$B$2:B8,B8)&IF(B8="Enterance Fees", IFERROR(VLOOKUP(A8,$G$2:$I$4,3,FALSE),""),""))

 

[bosco_yip]

Maybe,

In C2, formula copied down :

=IF(A2="","",COUNTIFS(A$2:A2,A2,B$2:B2,IF(B2="","",B2))&IF((ISNUMBER(MATCH(A2,G$2:G$4,0)))*(B2="Enterance Fees")," "&LEFT(A2),""))

 

[Hany ali]

Well done, excellent. It is really a wonderful equation .. Thank you very much