You could use an array formula:

=LOOKUP("", B2:B4&"", A2:A4)
or
=INDEX(A2:A4,MATCH(TRUE,B2:B4="",0))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

KWilde wrote:

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?

--

Dave Peterson