"Trying to return text for corresponding number"

[Marwan69]

Hello Guys and smile where ever you be...

I have a table (below) and trying to find the LARGER number (in a separate cell) which is ok with me. However, I'd like to return the text which is particular to that number. Let me illustrate more:

[TABLE="width: 399"]
<tbody>[TR]
[TD]Company[/TD]
[TD]Cash on hand and at banks[/TD]
[TD]Term deposits - (<= 3 mos)[/TD]
[TD]Term deposits - (>3<12 mos)[/TD]
[TD]FVIS Investment[/TD]
[/TR]
[TR]
[TD="align: left"]Malath[/TD]
[TD]13.76%[/TD]
[TD]0[/TD]
[TD]703.71%[/TD]
[TD]-100.00%[/TD]
[/TR]
[TR]
[TD="align: left"]UCA[/TD]
[TD]-52.17%[/TD]
[TD]0[/TD]
[TD]-100.00%[/TD]
[TD]-100.00%[/TD]
[/TR]
[TR]
[TD="align: left"]Takaful[/TD]
[TD]392.58%[/TD]
[TD]0[/TD]
[TD]-100.00%[/TD]
[TD]-100.00%[/TD]
[/TR]
[TR]
[TD="align: left"]Allianz[/TD]
[TD]37.68%[/TD]
[TD]0[/TD]
[TD]-100.00%[/TD]
[TD]845.57%[/TD]
[/TR]
</tbody>[/TABLE]
The LARGER here is 392.58 (In that particular Row: Cash on hand...etc), however, I want to return the company (in this case: Takaful) which is matching that LARGER number.

I tried to use the below formulars but neither worked for me:

IF(VLOOKUP(LARGE(AX7:AX10,1),AW7:BC10,1),VLOOKUP(LARGE(AX7:AX10,1),AW7:BC10,1),"")

and...

VLOOKUP(LARGE(AX7:AX10,1),AW7:BC10,1)

Any idea and sorry for the long story...

P.S. AX7:AX10 represents the column: Cash on hand and at banks
AW7:BC10 represents the table from: Malath to 845.57%

Many thanks,
Marwan

 

[strooman]

Formula in BB9 (or where ever): =INDEX($AW$7:$AW$10;MATCH(LARGE($AX$7:$AX$10;1);$AX$7:$AX$10;0))

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]

AW​

[/td][td]

AX​

[/td][td]

AY​

[/td][td]

AZ​

[/td][td]

BA​

[/td][td]

BB​

[/td][/tr][tr][td]

6​

[/td][td="bgcolor:#0070C0"]Company[/td][td="bgcolor:#0070C0"]Cash on hand and at banks[/td][td="bgcolor:#0070C0"]Term deposits - (<= 3 mos)[/td][td="bgcolor:#0070C0"]Term deposits - (>3<12 mos)[/td][td="bgcolor:#0070C0"]FVIS Investment[/td][td="bgcolor:#0070C0"]Result[/td][/tr]
[tr][td]

7​

[/td][td]Malath[/td][td]

13,76%​

[/td][td]

0​

[/td][td]703.71%[/td][td]-100.00%[/td][td][/td][/tr]
[tr][td]

8​

[/td][td]UCA[/td][td]

-52,17%​

[/td][td]

0​

[/td][td]-100.00%[/td][td]-100.00%[/td][td][/td][/tr]
[tr][td]

9​

[/td][td]Takaful[/td][td]

392,58%​

[/td][td]

0​

[/td][td]-100.00%[/td][td]-100.00%[/td][td="bgcolor:#FFFF00"]Takaful[/td][/tr]
[tr][td]

10​

[/td][td]Allianz[/td][td]

37,68%​

[/td][td]

0​

[/td][td]-100.00%[/td][td]845.57%[/td][td][/td][/tr]
[/table]

 

[Marwan69]

PERFECT☺! You made my day strooman. I wish you all the best. I've replaced the ; with , .

Many thanks,
Marwan

 

[strooman]

Thank you Marwan69. Clever you replaced the semicolon with comma. The semicolon is separator in The Netherlands but i think rest of the workd it's comma.
Glad it worked out.