I need a formula that provides the value in Column 'A' at Row 'X' where 'X' is the last row for which there is data in Column 'B'. In the below example this would mean - for the last row in Col 'B' that has a value what is the value in Col 'A'. In this case the result would be 'Apr'. I have a formula which finds the last value in Col 'B' which I do need (ie. 75), however, I now need a formula that provides the corresponding month (ie. Apr). Any suggestions? Thank you in advance.
|Col 'A'</SPAN>||Col 'B'</SPAN>|