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!