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.