Hi everybody,

I found information on how to return information in the furthest right cell using the formulas below:
1. =LOOKUP(9^9,3:3)
returns the last number in row 3

2. =LOOKUP(REPT("z",255),3:3)
returns the last text entry on row 3

3. =LOOKUP(2,1/(3:3<>""),3:3)
returns the last non-blank cell.

I was wondering if anyone could answer the questions I had regarding these.

1. I don't understand what this formula is searching for. I get that it is looking in row 3, but how does 9^9(I don't know what this means) make it search right?

2. For this one, I don't understand how searching for z repeated 255 times returns the last text cell in row 3.

3. This is the one that confuses me the most. It appears to be searching for the number 2 in the range 1/(nonblank cells in row 3), and returning the value from row 3 that it finds. I don't understand what the (1/(3:3<>"") is telling it to search for, and how the number 2 is related to that.

I really appreciate any enlightenment anyone is willing to provide. I've tried searching through google, this forum, and Microsoft's site, but I just can't seem to find explanations that make sense to me.

Thank you,
Brad