IFERROR with empty result in cell

[handri]

hi

this is my vlookup

=IFERROR(VLOOKUP(C6,'Database BA BB'!A3:C7,3,FALSE),"FAIL")

when C6 is empty will result E6 with FAIL text in cell. How do i make it empty. Only when C6 is fill with data.

thanks in advanced

 

[Aladin Akyurek]

Are you after one of these?

=IF(C6="","",IFERROR(VLOOKUP(C6,'Database BA BB'!A3:C7,3,FALSE),"FAIL"))

=IF(C6="","",IFERROR(T(VLOOKUP(C6,'Database BA BB'!A3:C7,3,FALSE)),"FAIL"))

 

[handri]

thank you Aladin, these work for me!! cheers

Are you after one of these?

=IF(C6="","",IFERROR(VLOOKUP(C6,'Database BA BB'!A3:C7,3,FALSE),"FAIL"))

=IF(C6="","",IFERROR(T(VLOOKUP(C6,'Database BA BB'!A3:C7,3,FALSE)),"FAIL"))

 

[Aladin Akyurek]

thank you Aladin, these work for me!! cheers

You are welcome. By the way, if you are copying down the formula, try to make the table range absolute. That is, 'Database BA BB'!$A$3:$C$7 instead of 'Database BA BB'!A3:C7.

 

[handri]

Yes i am using F4..