Find the first occurrence in column A and return the value of column B

[Hansulet]

I have a data base with 3 columns.

In the first column I have registered the ID of many persons.

I need a formula to find the first occurrence in column A and return in column C the value of column B, only for the first occurence

For example, the result must be as follows:

A B C
111 text 1 text 1
222 text 2 text 2
333 text 3 text 3
444 text 4 text 4
111 text 5 text 1
555 text 6 text 6
222 text 7 text 2
333 text 8 text 3

 

[bebo021999]

Book1
	A	B	C
7	111	a	a
8	222	c	c
9	111	d	a
10	333	f	f
Sheet2

Cell Formulas
Range	Formula
C7:C10	C7	=INDEX($B$7:$B$10,MATCH(A7,$A$7:$A$10,0))

 

[Hansulet]

Book1
	A	B	C
7	111	a	a
8	222	c	c
9	111	d	a
10	333	f	f
Sheet2

Cell Formulas
Range	Formula
C7:C10	C7	=INDEX($B$7:$B$10,MATCH(A7,$A$7:$A$10,0))

Thanks. It is working perfect!!!

 

[Hansulet]

Is it possible to update this formula so that, if in column B there is a specific text for the respective ID even if it is not the first appearance, to display it in column C?
If this specific text does not exist in column B for that ID, then column C should display the first occurrence in column B (as in the previous formula)

For example, the result must be as follows:

A B C
111 text 1 aaaaa
222 text 2 bbbb
333 text 3 text 3
444 text 4 text 4
111 aaaaa aaaaa
555 text 6 text 6
222 bbbb bbbb
333 text 8 text 3

 

[bebo021999]

111-text1
111-aaaa
==>aaaa (2nd match) (similar to 222)
333- text 3
333-text8
==> text 3 (1st macth)

What is the logic?

 

[Hansulet]

I'm sorry, it's my mistake that I expressed myself wrong and I apologize.

In fact, the result should be as follows:

A B C
111 text 1 aaaaa
222 text 2 aaaaa
333 text 3 text 3
444 text 4 text 4
111 aaaaa aaaaa
555 text 6 text 6
222 aaaaa aaaaa
333 text 8 text 3

I mean, my problem imposes 2 conditions:

1. If the text "aaaaa" is not found in column B, then in column C the first occurrence in column B for the respective ID (in column A) must be displayed. This condition is met by your formula, for which I thank you very much.

2. If the column "aaaaa" is found in column B, regardless of whether it is the first occurrence or not, it must be displayed in column C the text "aaaaa" for the respective ID.