=LOOKUP(2,1/(1-ISBLANK(16:16)),16:16)


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Box666" wrote in message
oups.com...
I am trying to use a formula to lookup a value. The value I want to
lookup is is the last item in row 16. Which at the moment is G16, but
in a few days it may well have moved to (say) L16.

Is Index the best way to try and find this moving target? or does any
one have a formula to find the last item in specific row .. or the last
item in a column which perhaps I can change to row.