Reply to thread

Message: [QUOTE="Prohock, post: 3625277"] I would like excell to look for at the text value in column A and if that value exists else wear in the spread sheet in column A, I would like it to return the value that is in the same row in column B, exculding the value being test for, in column C. If the value occurs twice I would like to CONCATENATE both column B values in the same cell for C. I would like this to occur to a maximum of three values. Please see the sample below: Columns A and B are entered data and column C is the calculated data. A B C 1 name class Desired results 2 jim hi 3 bob bye 4 jim hello hi 5 suzy audios 6 suzy good audios 7 bob bad bye 8 jim play hi hello 9 silly car 10 jim house hi hello play [/QUOTE]