March Month Last day value for every year

[thilag]

Hello Friends


File name : <March Month Last day value for every year.xlsx>
File Version : MS Office 2010

I want to lookup and display the value in Column B for the Last date of march month for the given year, All the values to be plotted in respective light green color cells.


thanks

thilag

[Crooza]

use this formula

=VLOOKUP(DATE(RIGHT(D5,4),3,31),$A$1:$B$1180,2)

maybe use CF for the shading

EDIT : Sorry thought you also wanted to shade column B. Ignore last comment

[FDibbins]

Nice 1 Crooza, you beat me to it

=VLOOKUP(DATE(RIGHT(D5,4),3,31),$A$1:$C$1180,2,1)

If you only want to show those values, use a helper with this, copied down in C2...
=IF(MONTH(A2)=3,IF(MONTH(A2)=MONTH(A3),"",B2),"")

Then apply filters and uncheck blanks

[Crooza]

@FDibbins. Thanks and Thanks for the rep points

[thilag]

Perfect solutions

thanks to Crooza and Ford

thanks again

thilag