software

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.

Last cell in column
=LOOKUP(9.99999999999999E 307,Sheet1!A:A) will return the last numeric value
of Sheet1 column A=LOOKUP(REPT(quot;zquot;,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

quot;TJW JRquot; gt; wrote in message
...
gt; OK, I know the limit of 7 nested ifs, and the vlookup function. But what
gt; I
gt; am try to do is the following:
gt;
gt; I have cells B2-B13 for invoice data. I want B1 to automatically populate
gt; with the last invoice, so moving down the cells, it would be the last
gt; non-blank value.
Try this:
B1: =INDEX(B2:B65535,MATCH(2,1/(1-ISBLANK(B2:B65535))))
Note: Commit that array formula by holding down the [Ctrl][Shift] keys and
press [Enter].Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;TJW JRquot; wrote:

gt; OK, I know the limit of 7 nested ifs, and the vlookup function. But what I
gt; am try to do is the following:
gt;
gt; I have cells B2-B13 for invoice data. I want B1 to automatically populate
gt; with the last invoice, so moving down the cells, it would be the last
gt; non-blank value.