I have entered a formula in Tab AG ORDERS in column L which is working but I want to adjust it so if column a is blank then it looks in column d and if the data in d matches, then it enters in the same info in column l.

SO example A22 - A29

I have data in A22, so the current formula in column L enters in data. I don't have data in A23 - A29 but the data in D23 - D29 all match, so I want the data that was entered in L22 to replicate in L23 - L29

Is this even possible.14-15 budget-AG test.xlsm