Hi,

You can do it, but its a rather tedious formuls:

=IF(A1=1,B1,"")&IF(A2=1,B2,"")&....

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Novice" wrote:

Can I concatenate cells in a coumn if cells in another column return a
particular value?

e.g.

A B
1 1 Text A
2 1 Text B
3 2 Text C
4 3 Text C
5 4 Text C
4 Text C

I would like the formula to find all instances of the value 1 (one) in
Column A and then concatenate only those Rows in Column B

result: Text A; Text B

I will need to repeat this exercise for 40 particular values.

I cannot use macros, addons, or VBA editor.

--
Thank you for your time

Novice