Please don’t judge but I have to use this formula ( I had to cut it shorter though as stackoverflow didn’t allow me to post mostly code), however it gives the “N/A” No match error message.
And the formula bar is underlined, so I was wondering if there’s a mistake in the syntax?

Please don’t judge but I have to use this formula ( I had to cut it shorter though as stackoverflow didn’t allow me to post mostly code), however it gives the “N/A” No match error message.
And the formula bar is underlined, so I was wondering if there’s a mistake in the syntax?