IF with CONCATENATE

[TrishG]

this is my first time using forum so please excuse any ignorance!

My issue is that I have three columns with 5000 rows of data (that are not stable). Rather then manually creating the result I am looking for, I would like to use a conditional formula but I have no idea how to write.

Here's the result I need:
Col A Col B Col C
XY 36 J

If Col A = XY then return X and concatenate Col B and Col C

So result would be "X36J"

Help!

[Sam Capricci]

welcome to the forum.
you could use =IF(A1="xy","x"&B1&C1,"") copied down.

[Saarang84]

Hi Trish,

Refer to the attached workbook, output in the column named Result

or you can use

Please Login or Register  to view this content.

[TrishG]

That works Sambo Kid -- thanks sooo much! I want to hit the "EASY" button -- but it was easy for you and a head scratcher for me

[Sam Capricci]

You're welcome and thanks for the reputation bump!
Just to make the moderators happy and as a housekeeping note, don't forget to mark your post as solved using the thread tools dropdown at the top of the post.

[TrishG]

ARGH -- I just realized I actually need to check if XY or AB and return X if XY or A if AB -- any idea what the modification to the formula is?

[Sam Capricci]

this should take care of that...
=IF(A1="xy","x"&B1&C1,IF(A1="ab","a"&B1&C1,""))
or you can try an alteration of what Saarang84 gave you or another option would be a table with your values then a vlookup off that. Depends on how many iterations you have.

[ben_hensel]

Nest an OR in the If-test, then use Saarang's approach.

Please Login or Register  to view this content.

[TrishG]

Thanks again!!!