Hi,
Hope someone here would be able to help.
I am working on automating benefits calculations for each financial year depending on the release date (which may change from time to time). Have tried numbers of ways using Index/Match, vlookup but struggling to get anything to work. I am attaching a dummy file with data and desired results I want. Please feel free to ask if anything is unclear.
Thanks in advance!!!
Regards, Punit.
Bookmarks