Thanks Richard, no wonder I couldn't figure it out.
Have tried to send you an attachment of part of my spreadsheet without luck but basically its always the TOP value in column H I want to copy to O2..
I add a new row with data every day above the last top data row and its that new top value I want to have appear in O2..
Your formula returns #N/A currently in O2 ?? presumably the "last" value in your formula
I hope this makes sense
Richard that's a handy website to know about
File ID is 933418
Hopefully that will help
Thank you again
Brilliant Richard thank you, XXXXX XXXXX a charm