Need Vlookup to return a result of "Not Recv'd not blank or N/A.

[misspaulaj]

Hi Everyone,

This formula is working perfectly for the most part but If the cell in the range is blank, I want it to return a result of "Not Recv'd" instead it is returning a blank. I don't want that. Help! I want it to return the same result of "Not Recv'd" for an error and a blank.

=IF(ISERROR(VLOOKUP(C2,'[CGD 2014 Monthly Master List.xlsm]1'!$A$7:$E$49,5,0)),"Not Recv'd",VLOOKUP(C2,'[CGD 2014 Monthly Master List.xlsm]1'!$A$7:$E$49,5,0))

 

[Aladin Akyurek]

What does the formula return when successful - text or number?

 

[vds1]

Try,

If formula returns blank text and error Try,

=IFERROR(IF(VLOOKUP(C2,'[CGD 2014 Monthly Master List.xlsm]1'!$A$7:$E$49,5,0)="","Not Recv'd",VLOOKUP(C2,'[CGD 2014 Monthly Master List.xlsm]1'!$A$7:$E$49,5,0)),"Not Recv'd")

If formula return zero (Number) and error,

=IFERROR(IF(VLOOKUP(C2,'[CGD 2014 Monthly Master List.xlsm]1'!$A$7:$E$49,5,0)=0,"Not Recv'd",VLOOKUP(C2,'[CGD 2014 Monthly Master List.xlsm]1'!$A$7:$E$49,5,0)),"Not Recv'd")

 

[misspaulaj]

What does the formula return when successful - text or number?

It returns "Not Recv'd" if cell result is a #N/A (which I want) but when the cell is blank, it returns a blank. I want it to return "Not Recv'd".

 

[Aladin Akyurek]

It returns "Not Recv'd" if cell result is a #N/A (which I want) but when the cell is blank, it returns a blank. I want it to return "Not Recv'd".

What do we have in column E - text or number?