If you mean return the right most value in a row then try for row 4:

=LOOKUP(2,1/4:4,4:4)

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"sm7301" wrote in message
...
I am using a spreadsheet to compile monthly results for my company. Some
results are YTD and I would like to have the most recent month show up for
the YTD total. Is there a formula I can input that will look for the last
entry in a particular row and populate that?