I am trying to lookup the value contained in the lowest populated row of an array of data.

So far I have been using LOOKUP(2,1 /(NOT(ISBLANK(B2:B12))),B2:B12) which has been working fine.

I now want to formulate B2:B12 with an if statement that makes them blank if another cell is empty. At this point the Lookup formula does not function anymore and will return the blank from B12. Any ideas on how to adjust the formula when the reference cells themselves work off a formula? Any help would be much appreciated. Thanks!