Excel VLOOKUP for blank cells

IS it possible to do an Excel function to do a VLOOKUP for the next blank cell, or do I have to code my own function. I have a situation like where column A is Owner and Column D is Value. I need a cell to return the Value of the first item not owned (that is, the value of column D, for the first blank cell in column A). I tried using a blank cell and "" as the Lookup_value parameter in the VLOOKUP funtion, but it always returns "#N/A". It seems like an Excel funtion should be able to do this without me coding something myself. Any ideas?

/I meant to post this in the VBA forum. Is there a way for me to move it?

Add a column with either '1' or '0' in it

Quote:

---

Originally Posted by dglienna

Add a column with either '1' or '0' in it

---

I don't understand where the 1 or 0 would come from or what I would do with the column. And I can't really add column to the existing for. It should be a contained function.