I have a small issue with an array function that I am trying to use in an excel sheet. I have one worksheet which contains monthly employee pension details, the first column being the employee pension number, across different years.
In the lookup sheet, the user should be able to enter the employee number and see the details generated . I am able to only obtain the first line with my array function, for april 2005 which is the first date. The second month onwards, the array function does not work. I am attaching a sample file. Could someone let me know what is wrong with my formula ? Slightly urgent.
Thanks a ton in advance.
Bookmarks