Excel Concatenante/IF/Textjoin Help

I'm trying to get some help with a concatenate / IF formula on a spreadsheet that I'm working on. Basically, what I need is to populate a field with user input only if they enter a value in a different field. I also need this field to populate text that I enter in the formula only if the user puts a value into the original field. Below is a example:

A B C
1 OBJECT VLAN NAME INPUT WHAT IM TRYING TO ACHIEVE
2
3 VLAN # 10 If there's input in B3 this field (C3) should read -VLAN- "B3" If no input is entered in "B3" this field (C3) should be blank


Capture.PNG

Is this what you want:

Formula:

Please Login or Register  to view this content.

The attachment didn’t work.


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

Your requirement was not clear.

Formula:

Please Login or Register  to view this content.

Did you see post #5?

Formula:

Please Login or Register  to view this content.

Your original post didn't mention multiple sheets. The formula was based on the "information" in the picture. Can't see why it would give a FALSE value … it's a very simple IF with two possible outcomes. The only issue would have been the fact that it didn’t refer to Sheet1.


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.