VLOOKUP if cell is empty return specific text instead of 0

[lunatu]

Hi,

is it possible with vlookup formula to return specific text if the cell is empty? I tried this formula =IFERROR(VLOOKUP(E2;'[Workbook1]Sheet1'!B$2:N$4000;7;FALSE);"Open") but it brings value 0 if the cell is empty (i would like it to return text "Open").

Thanks in advance!

 

[lunatu]

What sort of values is the vlookup returning, text or numbers?

Vlookup is returning number (=0) if the cell is empty but text if there is text in the cell (the cell is either empty or there is text in it).

 

[Phuoc]

Vlookup is returning number (=0) if the cell is empty but text if there is text in the cell (the cell is either empty or there is text in it).

If the result is text, you can try:


=TEXT(VLOOKUP(E2;'[Workbook1]Sheet1'!B$2:N$4000;7;FALSE);";;""Open"";@")