EDate a VLookup when VLookup comes up blank

[DerekMeers]

Good Afternoon

I am currently trying to add 12 months to a Vlookup formula result.
The Vlookup formula references another workbook.
The formula currently has an if statement to blank out the cell if the vlookup does not find a value.
I am wanting to add 12 months to the vlookup.
If the vlookup is blank, I want the Edate to be blank.

[TABLE="width: 500"]
[TR]
[TD]IF(ISNA(VLOOKUP(H10, '[Canada AssetsV2.xlsx]PM & CVIP'!$A$2:$CP$833, 35, FALSE)), " ", VLOOKUP(H10, '[Canada AssetsV2.xlsx]PM & CVIP'!$A$2:$CP$833, 35, FALSE))[/TD]
[TD]12[/TD]
[TD]=EDATE(A1,B1)[/TD]
[/TR]
[/TABLE]

The formula works perfect when there is a date found, but when the date is blank, I receive #VALUE .
I have tried to condition format the cell to make #VALUE white and hidden, but this also doesn't work.

Does anyone have any ideas?

Thank you!

 

[Toadstool]

Hi DerekMeers,

I suspect the retrieved cell 35 columns after the match is found in the remote file contains text and not a date.

Your pasted formula also looks a little funny but that may be due to a pasting problem.

=IF(ISNA(VLOOKUP(H10, '[Canada AssetsV2.xlsx]PM & CVIP'!$A$2:$CP$833, 35, FALSE)), " ", EDATE(VLOOKUP(H10, '[Canada AssetsV2.xlsx]PM & CVIP'!$A$2:$CP$833, 35, FALSE),12))

 

[DerekMeers]

The pasting does't help. I actually just figured it out.

=IFERROR(EDATE(A1,B1), " ")

I swear I tried this earlier.
Thank you for your help and sorry for posting in the wrong thread.

 

[Sam_D_Ben]

The pasting does't help. I actually just figured it out.

=IFERROR(EDATE(A1,B1), " ")

I swear I tried this earlier.
Thank you for your help and sorry for posting in the wrong thread.

EDATE(A1,B1), This is something new to me.