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.