Vlookup

[Abdulkhadar]

Hello Excel Experts,
I want to lookup the values in decreasing order from column A then lookup the data from Column B with matching with decreasing ordered value at Column F. i. e as follows

	A	B	C	D	E	F
1	marks	name		rank		name
2	580	amk		1	=LARGE(A:A,D2)	amk
3	475	rak		2	=LARGE(A:A,D3)	dam
4	525	and		3	=LARGE(A:A,D4)	znd
5	568	znd		4	=LARGE(A:A,D5)	tab
6	567	arm		5	=LARGE(A:A,D6)	arm
7	580	dam
8	375	tan
9	568	tab

<colgroup><col><col span="4"><col><col></colgroup><tbody>
</tbody>

I use the formula at col F =VLOOKUP(LARGE(A:A,D2),A:B,2,FALSE)
but it shows the same name for the same value.
Thanks in advance

 

[Aladin Akyurek]

Book1
	A	B	E	F
1	marks	name	marks	name
2	580	amk	580	amk
3	475	rak	580	dam
4	525	and	568	znd
5	568	znd	568	tab
6	567	arm	567	arm
7	580	dam	525	and
8	375	tan	475	rak
9	568	tab	375	tan
10
Sheet1

In E2 just enter and copy down:

=LARGE($A$2:$A$9,ROWS($E$2:E2))

In F2 control+shift+enter, not just enter, and copy down:

=IF($E2="","",INDEX($B$2:$B$9,SMALL(IF($A$2:$A$9=$E2,ROW($B$2:$B$9)-ROW($B$2)+1),COUNTIFS($E$2:E2,E2))))

 

[Abdulkhadar]

	A	B	E	F
1	marks	name	marks	name
2	580	amk	580	amk
3	475	rak	580	dam
4	525	and	568	znd
5	568	znd	568	tab
6	567	arm	567	arm
7	580	dam	525	and
8	375	tan	475	rak
9	568	tab	375	tan
10

<colgroup><col style="width: 25pxpx"><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

In E2 just enter and copy down:

=LARGE($A$2:$A$9,ROWS($E$2:E2))

In F2 control+shift+enter, not just enter, and copy down:

=IF($E2="","",INDEX($B$2:$B$9,SMALL(IF($A$2:$A$9=$E2,ROW($B$2:$B$9)-ROW($B$2)+1),COUNTIFS($E$2:E2,E2))))

Wow nice, thanks sir,

 

[Aladin Akyurek]

Wow nice, thanks sir,

You are welcome.