Last cell in column
=LOOKUP(9.99999999999999E+307,Sheet1!A:A) will return the last numeric value
of Sheet1 column A


=LOOKUP(REPT("z",255),Sheet1!A:A) will return the last text entry of Sheet1
column A

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"TJW JR" wrote in message
...
OK, I know the limit of 7 nested ifs, and the vlookup function. But what
I
am try to do is the following:

I have cells B2-B13 for invoice data. I want B1 to automatically populate
with the last invoice, so moving down the cells, it would be the last
non-blank value.