Nested ifs and conditional population
 

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.

Nested ifs and conditional population
 

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.

Nested ifs and conditional population
 

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.