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

#### misspaulaj

##### New Member
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))

### Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

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

#### vds1

##### Well-known Member
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

##### New Member
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".

##### MrExcel MVP
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?

Replies
3
Views
141
Replies
9
Views
586
Replies
9
Views
471
Replies
9
Views
449
Replies
26
Views
1K

1,191,557
Messages
5,987,269
Members
440,087
Latest member
Ruppert23

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back