VBA : conditional based on text

[wingfield65]

Hello,

I'd like to have VBA code that inputs a single formula that I can copy down to the last row. the amount of rows will always vary. the conditional would check for the words "passenger list" in column C. if this text is found, then one sentence would be constructed from text in other columns. if this text is not found, then a different sentence would be constructed; again with text from the other columns. the attached excel file shows the desired outcome in column Q.

I've done something similar before where an exact match is looked for; but haven't figured out how to do this with a "contain" type conditional. any help would be appreciated. I hope this all makes sense. I'll provide more context if necessary.

I've pasted below (first code) some code I've used in the past that has been successful (actually more complicated in that it has nested conditionals); but again with an exact match. I provide this just to show what I'm used to (yeah, I'm a hack and it's not pretty, but it works); but I'm open to whatever formula might be provided.

Please Login or Register  to view this content.

this 2nd code is my rather feeble attempt to do what I'm looking for.

Please Login or Register  to view this content.

[TMS]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

[wingfield65]

Trevor - sorry about that. I forgot. the attachment is there now.

[TMS]

Try this:

Please Login or Register  to view this content.

[wingfield65]

Trevor,

Brilliant! Thank you so much. exactly what I was looking for.

Best Regards,

David

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.