PS: the formula works on a separated spread sheet and for the example i had made, but not for spread sheet i am using for my analysis.....thanks for your feedbacks, James006 and Fluff, but i still dont understand why it does not work..
here a print screen of what i have done.
PS: unfortunately the web site does not allow to insert pic from a desktop directory
Once i implement the Worksheet Formulas i get the figures that are relative to 2019. In all other cases (for those companies whose most recent value is before 2019) i dont get any result (the cell is blank).