Excel formula: ​ Two Financial Year Ends for one Client

Gerberreinette Posts 14 Registration date Friday March 4, 2016 Status Member Last seen July 31, 2023 - Jul 31, 2023 at 04:56 AM


Thank you so much for putting time aside in helping me with the following formula.

In Column O on the Main sheet, I do a VLOOKUP from the master data sheet to get the correct FYE, but my formula is not working. I tried a view tests in column K to N to assist with my formula in column O without any luck.

The FYE for the client changed on 20220228. For 2020 and 2021 it must show FYE FIRST 02 and for 2022 from line 11 onwards it should show FYE SECOND 12.

Thank you, much appreciated.