How to make this formula return a blank if no value

[htchandler]

On this formula: =VLOOKUP(E2,'MRC Reason'!$A$2:$F$423,6,TRUE) I want it to just give me a blank cell if the value of the lookup has nothing in it. Can anyone give me advice on how to make this happen? I tried adding an if then statement but it failed.

 

[gbell3587]

On this formula: =VLOOKUP(E2,'MRC Reason'!$A$2:$F$423,6,TRUE) I want it to just give me a blank cell if the value of the lookup has nothing in it. Can anyone give me advice on how to make this happen? I tried adding an if then statement but it failed.

try this

=IF(ISNA(VLOOKUP(E2,'MRC Reason'!$A$2:$F$423,6,TRUE)),"",(VLOOKUP(E2,'MRC Reason'!$A$2:$F$423,6,TRUE)))

You could also substitute 'ISNA' for 'ISBLANK'.

 

[htchandler]

That is still returning a value of "0". I even tried getting it to return "Item Not Found" and it still came up with "0".

 

[Cindy Ellis]

Try this...

=IF(VLOOKUP(E2,'MRC Reason'!$A$2:$F$423,6,TRUE)=0,"",VLOOKUP(E2,'MRC Reason'!$A$2:$F$423,6,TRUE))

 

[T. Valko]

On this formula: =VLOOKUP(E2,'MRC Reason'!$A$2:$F$423,6,TRUE) I want it to just give me a blank cell if the value of the lookup has nothing in it. Can anyone give me advice on how to make this happen? I tried adding an if then statement but it failed.

What is the data type of the value being returned if it's not an empty cell? Is it text, numeric, could be either?

Is 0 an otherwise valid result?

 

[shift-del]

Display or hide zero values

http://office.microsoft.com/en-us/excel-help/display-or-hide-zero-values-HP010070461.aspx

 

[htchandler]

Formating the cells worked perfect, thank you.