avoid #N/A error using =RANK formula

[redspanna]

Hey all

I have a simple list of numbers that I'm using the =RANK formula to show the TOP 5

NDA.v8.xlsm
	B	C	D	E	F
1	NUMBER	RANK
2	17	4		Top 5
3	9	8		1	23
4	3	10		2	21
5	17	4		3	19
6	23	1		4	17
7	6	9		5	#N/A
8	19	3
9	21	2
10	11	7
11	12	6
Sheet1

Cell Formulas
Range	Formula
F3:F7	F3	=XLOOKUP(E3,$C$2:$C$11,$B$2:$B$11)
C2:C11	C2	=RANK(B2,$B$2:$B$11)

Is there a way to avoid the situation where I have two numbers having the same value thus getting the #N/A error as shown in this example
If possible instead of the error just show the same value that it would be equal to - so in my example above F7 would show the value of 17 as this is EQUAL 4th place

Hope this makes sense and thanks in advance

 

[Fluff]

How about

+Fluff 1.xlsm
	B	C	D	E	F
1	NUMBER	RANK
2	17	4		Top 5
3	9	8		1	23
4	3	10		2	21
5	17	4		3	19
6	23	1		4	17
7	6	9		5	17
8	19	3
9	21	2
10	11	7
11	12	6
12
Data

Cell Formulas
Range	Formula
F3:F7	F3	=INDEX(SORT(B2:C11,2),SEQUENCE(5),1)
C2:C11	C2	=RANK(B2,$B$2:$B$11)
Dynamic array formulas.