Need Formula help for current value

[aparvez007]

Hi,

Please help me to solve the formula for my dashboard. I have spreadsheet where I will update the price daily I want current value column U should calculate the last updated price.
Sample file attached.

Thanks,
pAvi

 

[herofox]

TRY THIS

=IFERROR(B8*LOOKUP(2,1/((C8:T8>0)),C8:T8),"")

 

[aparvez007]

TRY THIS

=IFERROR(B8*LOOKUP(2,1/((C8:T8>0)),C8:T8),"")

Thanks alot perfect fit

 

[bosco_yip]

Or this shorter one

=IF(B8="","",B8*LOOKUP(9^9,C8:T8))

Regards
Bosco

 

[aparvez007]

Or this shorter one

=IF(B8="","",B8*LOOKUP(9^9,C8:T8))

Regards
Bosco

Thanks this too working