Formula to do the following special scenario

[PrashanthGM12345]

Hi

I have 2 tables Table A and Table B
Table A has 2 columns Audit Month and Audit Score monthly wise score.
Table B has 2 Cells Audit Month and Audit Score

I am struck while trying to find a formula for the below case:
I want a formula which will scan the entire Column A and Column B in table A and it will copy the last filled Audit Month and Audit Score.
Later it should paste the same in the cell D3 and E3 respectively.

I have attached the file for reference.

 

[AliGW]

In D3:

=LOOKUP(2,1/($B$4:$B$15<>""),A$4:A$15)

In E3:

=LOOKUP(2,1/($B$4:$B$15<>""),B$4:B$15)

 

[bosco_yip]

In D3, formula copied right to E3 :

=LOOKUP(9^9,A$4:A$15/($B$4:$B$15<>""))

Regards
Bosco

 

[PrashanthGM12345]

Thanks a lot AliGW

 

[PrashanthGM12345]

Thanks a lot bosco_yip

 

[AliGW]

You're welcome!