Using vlookup against blank cell

B

bam

I am using vlookup to return values (lets say values A-I) based on other
values (Values 1-10) in column A.
Sometimes there is no value in column A and I'd like vlookup to return a
value "blank cell" or whatever I define.
Right now blank cells return N/A.
I am guessing there is something simply I can do there.

Thanks in advance

bmac
 
T

T. Valko

One way:

Assuming the lookup_value is in cell D1.

=IF(COUNTIF(A1:A10,D1),VLOOKUP(D1,A1:B10,2,0),"your_message_here")
 
Top