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.

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))

12

=EDATE(A1,B1)

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.