2nd to last value in a column with blanks, find value in next column

[LookIWashed4Supper]

Hi

Yesterday I received help finding the 2nd to last value in a column with blanks. The formulae is;

=INDEX(B1:B100,LARGE(INDEX((B1:B100<>"")*ROW(B1:B100),0),2))

Now I need to find the value in the same row, but comumn A. Column A has dates in it. I have tried the following;

=INDEX($A$1:$A$94,MATCH(INDEX(B1:B94,LARGE(INDEX((B1:B94<>"")*ROW(B1:B94),0),2)),B$1:B$94))

However it is giving me the date in column A corresponding to a cell in column B which has the same value as the 2nd to last value, but isn't the second to last row.

Your help would be greatly appreciated.

[Tony Valko]

=INDEX(B1:B100,LARGE(INDEX((B1:B100<>"")*ROW(B1:B100),0),2))

All you should have to change is the 1st INDEX range:

=INDEX(A1:A100...

[LookIWashed4Supper]

That's it! It even makes sense. Thanks heaps for your help.

[Tony Valko]

You're welcome. Thanks for the feedback!