If [range of cells] contains 'text1' or 'text2', or, ... , return that text here.

[TwinkleW]

Hello, I'm sure this is painfully simple, but not until you know how!
Into each cell A_i in column A, I want to return whatever text is in the range of cells B_i:D_i.
For example: for row 2, I want Excel to check if there is any text in cells B2, C2 or D2 and if so, return that text into A2, otherwise, leave A2 blank (there will be text in only one cell, if any).

I may want to extend the search rage to more than three cells in the row.
(I know it seems a bit pointless but this is not the actual text.)
Thank you.

Book1
	A	B	C	D
1	X,Y, or Z?	X	Y	Z
2			Y
3		X
4				Z
5			Y
6		X
7			Y
8		X
9				Z
Sheet1

 

[hrayani]

Hi,
is this what you want ??

Book6
	A	B	C	D
1	X,Y, or Z?	X	Y	Z
2	Y		Y
3	X	X
4	Z			Z
5	Y		Y
6	X	X
7	Y		Y
8	X	X
9	Z			Z
Sheet1

Cell Formulas
Range	Formula
A2:A9	A2	=CONCATENATE(B2,C2,D2)

 

[TwinkleW]

Hi,
is this what you want ??

Book6
	A	B	C	D
1	X,Y, or Z?	X	Y	Z
2	Y		Y
3	X	X
4	Z			Z
5	Y		Y
6	X	X
7	Y		Y
8	X	X
9	Z			Z
Sheet1

Cell Formulas
Range	Formula
A2:A9	A2	=CONCATENATE(B2,C2,D2)

Perfect, thank you

 

[hrayani]

Perfect, thank you

you are welcome & thanks for the feedback

 

[TwinkleW]

you are welcome & thanks for the feedback

Hello again and sorry to bother you but would you happen to know how I would then sum the amounts in column A, but only for the Y's in column B?
So just adding 45 + 56 + 54 (for example)
Thank you

Book1
	A	B	C	D	E
1	Amount	X,Y, or Z?	X	Y	Z
2	45	Y		Y
3	21	X	X
4	32	Z			Z
5	56	Y		Y
6	78	X	X
7	54	Y		Y
8	98	X	X
9	42	Z			Z
Sheet1

Cell Formulas
Range	Formula
B2:B9	B2	=CONCATENATE(C2,D2,E2)

 

[hrayani]

I am not sure where you want the formula result
I have inserted the formula just below the amount list in cell A10

Or is there anything, I have misunderstood ???

Book6
	A	B	C	D	E
1	Amount	X,Y, or Z?	X	Y	Z
2	45	Y		Y
3	21	X	X
4	32	Z			Z
5	56	Y		Y
6	78	X	X
7	54	Y		Y
8	98	X	X
9	42	Z			Z
10	155
Sheet1

Cell Formulas
Range	Formula
B2:B9	B2	=CONCATENATE(C2,D2,E2)
A10	A10	=SUMIF(B2:B9,"Y",A2:A9)

 

[TwinkleW]

I am not sure where you want the formula result
I have inserted the formula just below the amount list in cell A10

Or is there anything, I have misunderstood ???

Book6
	A	B	C	D	E
1	Amount	X,Y, or Z?	X	Y	Z
2	45	Y		Y
3	21	X	X
4	32	Z			Z
5	56	Y		Y
6	78	X	X
7	54	Y		Y
8	98	X	X
9	42	Z			Z
10	155
Sheet1

Cell Formulas
Range	Formula
B2:B9	B2	=CONCATENATE(C2,D2,E2)
A10	A10	=SUMIF(B2:B9,"Y",A2:A9)

Brilliant again Thanks so much. You're a star

 

[hrayani]

Thanks so much

You are welcome

You're a star

NO! I am not

 

[TwinkleW]

You are welcome


NO! I am not

Surely that's in the eye of the beholden??