Rank in a list (more than one)

[Ongbey]

Hi,

My goal is to find a word/number (example Orange in here) rank in a list. So, when I write "Orange" to the cell C1, I must obtain 3, 6 and 9. First rank can be obtain with MATCH formula, but I cannot obtain 2. and 3. rank with this formula.
I don't want to use array formula. Because, my data is in another book and array formulas make problem.

Thanks, in advance.

List		Orange
Blue		3	6	9
Black
Orange
Yellow
White
Orange
Brown
Magenta
Orange
Red

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F
1	List		Orange
2	Blue		3	6	9
3	Black
4	Orange
5	Yellow
6	White
7	Orange
8	Brown
9	Magenta
10	Orange
11	Red
12
Main

Cell Formulas
Range	Formula
C2:F2	C2	=IFERROR(AGGREGATE(15,6,(ROW($A$2:$A$100)-ROW($A$2)+1)/($A$2:$A$100=$C$1),COLUMNS($C2:C2)),"")

 

[Ongbey]

Formula works perfect. Thanks

 

[Fluff]

You're welcome & thanks for the feedback.