Looking to find a value from a column

Maybe something like this...

Data Range

	A	B	C	D
1	Position	Value	------	Result
2	C	9		22
3	C	35
4	P	70
5	LF	63
6	CF	46
7	C	22
8	2B	88
9	2B	14
10	3B	18
11	SS	59
12	C	20

This array formula** entered in D2:

=INDEX(B:B,SMALL(IF(A2:A12="C",ROW(A2:A12)),3))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

Due to space limitations I can't post an example with 30 Cs in the data. So, the example finds the 3rd C.

If you want the 30th just replace the 3 with 30.

You're welcome. Thanks for the feedback!