Nested ifs and conditional population

[TJW JR]

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.

[Bernard Liengme]

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" <[email protected]> wrote in message
news:[email protected]...
> 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.

[Ron Coderre]

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-Pro


"TJW JR" wrote:

> 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.