Formula to populate cell if source is blank

[kenadams378]

HI,

I have a formula

Please Login or Register  to view this content.

Currently the returning value is (blank) in cell AK2 but i need to adapt the formula to return the value in E2 if D2 is blank?

Anyone have an idea how?

I've attached the workbook to help.

Regards

[Jonmo1]

Perhaps

=IF($AI2="YES",IF(VLOOKUP($AJ2,Sheet2!$A:$BT,3,0)="X",IF($D2="",$E2,$D2),""),"")

[dilipandey]

Okay.. try using below formula:-

Please Login or Register  to view this content.

Regards,
DILIPandey
<click on below * if this helps>

[kenadams378]

Thank you both very much!

[Jonmo1]

You're welcome, thanks for the feedback.