I'm trying to reference a null value in the lookup function and I keep
getting #NA back in return. Is there anyway I can do this?
=Lookup("", B2:B4, A2:A4) gives me #NA.

Basically in column B I want to lookup the first blank cell and want to
return the contents in column A in the same row. How can I do this?