Using vlookup against blank cell

  • Thread starter Thread starter bam
  • Start date Start date
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
 
One way:

Assuming the lookup_value is in cell D1.

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