Use the SWITCH function:
=SWITCH(IFERROR(INDEX(FILTER([Recording.xlsx]Wednesday!$D$2:$D$26,[Recording.xlsx]Wednesday!$B$2:$B$26<>""),ROW()-2),""),"Y","Accepted","N","Refused","")
This way, you avoid ...READ MORE
Feb 3, 2023
in Others
by
narikkadan
• 63,680 points
•
586 views