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!

 

[Fluff]

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

 

[Phuoc]

Try this:

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

 

[lunatu]

Try this:

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

Awesome, this is working perfectly! Thanks

 

[lunatu]

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

I got solution below

 

[Fluff]

There maybe a simpler solution depending on what type of data is being returned, which is why I asked.

 

[Sufiyan97]

Hello @Fluff
I would like to know another formula except in post #3 for the same situation
what would be that?

 

[Fluff]

Depends on what sort of data is being returned.

 

[Sufiyan97]

if cell is blank in returned data so instead of showing 0 we want blank or any text then?

 

[Fluff]

That does not answer my question & only the OP can tell us that.