## Use formula to create a sentence.

SilverLounger
Posts: 2155
Joined: 23 Feb 2010, 12:07

### Use formula to create a sentence.

Hi anyone,

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))``
to create a sentence as follows
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.
You do not have the required permissions to view the files attached to this post.
Best Regards,

HansV
Posts: 71516
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

### Re: Use formula to create a sentence.

=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)," is confirmed for ",TEXT(\$O\$10,"dd/mm/yyyy"),", shipping between ",VLOOKUP(V4,\$C\$12:\$L\$1000,3,FALSE),". Thank you for your cooperation")
Regards,
Hans