How to extract the last value in a row?

[delvillardennis]

Hello, please help me with a formula to extract the last value in row (refer attached sample file). Thank you...https://www.dropbox.com/s/z6sf2q0r1mktdje/DDV Sample_16Mar16.xlsx?dl=0

sorry, i am having problem uploading the file so I just provided the dropbox link

 

[bosco_yip]

Try,

T9, formula copy across to U9

=LOOKUP(9^9,$AA9:$AU9/($AA4:$AU4=T4)/($AA9:$AU9<>""))

Regards
Bosco

 

[delvillardennis]

Hi bosco, great help ...one more thing...how to avoid getting "#N/A" if there is no value yet to return?

 

[chirayu]

Put an IFERROR on the outside

 

[delvillardennis]

got it!...Many thanks Bosco and Chirayu...