Formula to find the same text in a column and return it's corresponding value in another column

[JLouis]

I am trying to extract data where I search for a specific test string in a column list and return a value from a corresponding column list. There are multiple instances of the specific text and I need the values to all of them. For example:

		FORMULA
NAME	VALUE	RESULT
A	1	1
B	2
C	3
A	4	4
E	5
F	6
A	7	7
F	8
A	9	9
A	10	10

Mini-sheets are cool!

 

[Fluff]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

If you have 365 how about

+Fluff 1.xlsm
	M	N	O
1			FORMULA
2	NAME	VALUE	RESULT
3	A	1	1
4	B	2
5	C	3
6	A	4	4
7	E	5
8	F	6
9	A	7	7
10	F	8
11	A	9	9
12	A	10	10
Main

Cell Formulas
Range	Formula
O3:O12	O3	=IF(M3:M12="A",N3:N12,"")
Dynamic array formulas.

 

[DanteAmor]

deleted

 

[DanteAmor]

Maybe I missed something, if so continue with Fluff's formula.

Libro1
	M	N	O
1			FORMULA
2	NAME	VALUE	RESULT
3	A	1	1
4	B	2
5	C	3
6	A	4	4
7	E	5
8	F	6
9	A	7	7
10	F	8
11	A	9	9
12	A	10	10
Hoja1

Cell Formulas
Range	Formula
O3:O12	O3	=IF(M3="A",N3,"")

 

[Fluff]

@DanteAmor You haven't missed anything, it's just if the OP has 365 the formula only needs to go in 1 cell & it spills down.
It's also nice to see you back.

 

[JLouis]

=IF(M3:M12="A",N3:N12,""

This worked simplistically perfectly. I won't mention all the vlookups and index/matches I tried before asking. Well done.

 

[JLouis]

@DanteAmor You haven't missed anything, it's just if the OP has 365 the formula only needs to go in 1 cell & it spills down.
It's also nice to see you back.

I discovered that.

 

[Fluff]

Glad we could help & thanks for the feedback.

PS. Please don't forget to update your account details to show what version/platform you are using.

 

[DanteAmor]

It's also nice to see you back.

I already missed this, I had a bad time but I'm better. Thanks for the welcome.