I'm in need of help to make the following formula

Code: Select all

`=CONCATENATE(VLOOKUP(V4,$C$12:$L$1000,7,FALSE),". Your payment for ",VLOOKUP(V4,$C$12:$L$1000,4,FALSE)," half of ",VLOOKUP(V4,$C$12:$L$1000,5,FALSE)," between ",VLOOKUP(V4,$C$12:$L$1000,3,FALSE))`

Dear Adam Smith. Your Payment for first half of goods material is confirmed for 10/05/2021 shipping between 22:00 - 23:00. Thankyou for your corporation.

I have attached the workbook for reference.

Any help would be appreciated.