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.