Hi,

I use a LOOKUP(9^9,... to pick the last cell with a value in a row, but somebody just gave me this parameter, but I couldn't find anything explaining these.
I tried also 7^7, 8^8, which seem to do the same thing. Others like 1^1, 2^2,... don't seem to work.

Any ideas?

Thanks
xingo