Blank Vlookup

[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

 

[Frank Kabel]

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

 

[collingrey]

Thanks I will try i