Blank Vlookup

C

collingrey

I want to know if a table has a blank field and I want this blank fiel
returned as Tomato, I use Vlookup for all the other results, but if i
is blank I need it to be retured as Tomato, any ideas?

Colli
 
F

Frank Kabel

Hi
maybe something like
=IF(A1="","Tomato",VLOOKUP(A1,lookup_range,col_index,0))
 
Top