V-Look up formula help

[MattExcelLearner]

Hi all

I have a v-look up working on column G, it pulls the correct dates in (I believe) once the required data in the formula is filled in.

My only issues is when all the data isn't completed like in this example column C has blanks so Column G pulls through the result of the project name.

As the data is automated from the Data tab there will be blanks in the data every now and again.

What I would like is if this happens then to have Column G bring through the result of as blank. Is this possible?

Thanks

[BMV]

try this
=IFERROR(VLOOKUP(A9,Table_owssvr_1,MATCH(MID(SUBSTITUTE("*"&LEFT(INDEX(Table_owssvr_1[Current Stage Gate],MATCH(A9;Table_owssvr_1[Title],)),5)&"*","**",""),2,6);Table_owssvr_1[#Headers],),),"")

[MattExcelLearner]

Awesome MMV, looks to work, much appreciated

Thanks