I have a spreadsheet with forecast dates and completion dates. What I want to do is a vlookup to capture actual dates. However, if the result is blank then I want to enter a formula.

This is what I have but doesn't work:

=IF(VLOOKUP(A4,Sheet1!$A:$BF,30,0)=" ",V4+5,VLOOKUP(A4,Sheet1!$A:$BF,30,0))

and

=IFERROR(VLOOKUP(B5,Sheet1!$B:$BF,29,0),V5+5)


So in sheet1 is what I call the raw data. Sheet 2 has a vlookup to pull the information from sheet1. Now I need to the formula in sheet2. If the vlookup returns a blank then B2+5.

So in sheet2 cell C3, if the vlookup returns a blank then B3+5.

I have attached a sample spreadsheet.


Thank you in advance for your assistance.

Attached Files

Sample_S01.xlsx (11.9 KB, 12 views)