Use formula to create a sentence.

User avatar
adam
SilverLounger
Posts: 2347
Joined: 23 Feb 2010, 12:07

Use formula to create a sentence.

Post by adam »

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,
Adam

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Use formula to create a sentence.

Post by HansV »

How about

=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")
Best wishes,
Hans

User avatar
adam
SilverLounger
Posts: 2347
Joined: 23 Feb 2010, 12:07

Re: Use formula to create a sentence.

Post by adam »

Thankyou very much Hans. It worked well.
Best Regards,
Adam