Help with "index" .. I think
=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.
|