Stuck with simple drop down list.

Firstly, hi to everyone on this forum
I have over the last week been given a new position at work because of a back injury which has taken me off the tools into the office. I am fairly decent at finding my way around a computer but excel is new to me and I really want to prove myself at work.
I was asked to assemble a quoting document that writes out its own letter to go to the customer. I used vlookup and data validation to create drop down list. I am almost done but I am struggling with the letter part.

My dropdown list look like this with =('Roof Quote'!A5&","&'Roof Quote'!A6) to write the letter. I modified it to this =IF('Roof Quote'!A5="Profile","",'Roof Quote'!A5&",") because as you can see on the images below it adds the text to a letter that may not be needed or wanted. My problem is how do I get the formula to only add the text if it is needed on two or more cells. example Only add text once it has been selected from the dropdown list. So if the list header is 'Profile' It wont add the text unless you have selected something other than that.
1.jpg
2.jpg
3.jpg

Thank you and I hope I have explained my situation well enough for you guys to understand

Hi, welcome to the forum

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

Having said that...

So if the list header is 'Profile' It wont add the text unless you have selected something other than that.

looks like you already have that covered?

=IF('Roof Quote'!A5="Profile","",'Roof Quote'!A5&",")

If you need to test for something else as well, then maybe something like this...
=IF(AND('Roof Quote'!A5="Profile",A6=""),"",'Roof Quote'!A5&",")

see attached example on how you could possibly do it
have the bits on the right hidden so it wont show up when you print the letter

Originally Posted by FDibbins

Hi, welcome to the forum

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Having said that...

looks like you already have that covered

Sorry I tried attaching a sample on Firefox and chrome but nothing happens when I click the attachment icon. But you can grab it from HERE
I have almost got it but I cant get it to add 2 or more from different cells on the Roof Quote page. Thanks

We are having problems with the upload icon, sorry

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Can Anyone Help?

Basically I just dont know how to join these into one working formula

=IF('Roof Quote'!A5="Profile","",'Roof Quote'!A5&",")
=IF('Roof Quote'!A6="Profile","",'Roof Quote'!A6&",")

So it would come out something like =IF('Roof Quote'!A5="Profile","",'Roof Quote'!A5&",", IF('Roof Quote'!A6="Profile","",'Roof Quote'!A6&","))
At the moment it tells me there are too many arguments

did you look at my file?

is this what your after?

Formula:

Please Login or Register  to view this content.

on your file A6 doesnt even have Profile as an option? so it will always be false?

you were missing a bracket?

Formula:

Please Login or Register  to view this content.