I'm wanting to find the last row used in a worksheet and a msg here said to use
= lookup(10^10,A:A)
I'm guessing that's a worksheet formula.
But I don't get what 10 raised to 10 means ??
From example
LOOKUP(lookup_value, lookup_vector, [result_vector])
I tried = Lookup("Fred"...