Match value with other value in difference sheet

[sulthonm]

Hi guys,
Could you help me, please?

I have a big data and many row. I have 2 sheet, sheet 1 have column name, netto and fee. Sheet 2 is like sheet 1. But field from sheet 1's not like sheet 2. Sheet 1 have data cell in netto, sheet 2 have data cell in fee. My expectation result if Neo A have the largest netto in sheet 1, so match value's fee in sheet 2 have fill in value in largest value Neo A in Expectation's result. My example's data like that. How the function/ formulas? Thank you.

Sheet 1 :
[TABLE="width: 202"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Netto[/TD]
[TD]Fee[/TD]
[/TR]
[TR]
[TD]Neo A[/TD]
[TD="align: right"]900[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]Neo A[/TD]
[TD="align: right"]200[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]Neo A[/TD]
[TD="align: right"]500[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]Aportase B[/TD]
[TD="align: right"]700[/TD]
[TD]-[/TD]
[/TR]
[TR]
[TD]Aportase B[/TD]
[TD="align: right"]800[/TD]
[TD]-[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 202"]
<tbody>[TR]
[TD][TABLE="width: 202"]
<tbody>[TR]
[TD]Sheet 2 :[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]Netto[/TD]
[TD]Fee[/TD]
[/TR]
[TR]
[TD]Aportase B[/TD]
[TD]-[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Neo A[/TD]
[TD]-[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]Neo A[/TD]
[TD]-[/TD]
[TD]90[/TD]
[/TR]
[TR]
[TD]Aportase B[/TD]
[TD]-[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]Neo A[/TD]
[TD]-[/TD]
[TD]40[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Expectation's result :
[TABLE="width: 192"]
<tbody>[TR]
[TD]Name[/TD]
[TD="width: 64"]Netto[/TD]
[TD="width: 64"]Fee[/TD]
[/TR]
[TR]
[TD]Neo A[/TD]
[TD="align: right"]900[/TD]
[TD="align: right"]90[/TD]
[/TR]
[TR]
[TD]Neo A[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD]Neo A[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]40[/TD]
[/TR]
[TR]
[TD]Aportase B[/TD]
[TD="align: right"]700[/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]Aportase B[/TD]
[TD="align: right"]800[/TD]
[TD="align: right"]30

[/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

Is Expectation a different sheet? If so, what is given in Expectation?

 

[sulthonm]

Is Expectation a different sheet? If so, what is given in Expectation?

The expectation result heve formed from :
1. largest netto's value Neo A in sheet A match with largest fee's value Neo A in sheet B.
2. smallest netto's value Neo A in sheet A match with smallest fee's value Neo A in sheet B.
3. And then, all series value match between fee with netto

 

[Aladin Akyurek]

The expectation result heve formed from :
1. largest netto's value Neo A in sheet A match with largest fee's value Neo A in sheet B.
2. smallest netto's value Neo A in sheet A match with smallest fee's value Neo A in sheet B.
3. And then, all series value match between fee with netto

Is it a different sheet? If it's, what is given? Name?

 

[sulthonm]

Is it a different sheet? If it's, what is given? Name?

Yes sir, basic column only in name.

 

[Aladin Akyurek]

Yes sir, basic column only in name.

Still incomplete info.

Sheet1

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

A​

[/td][td]

B​

[/td][td]

C​

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

1​

[/td][td] Name[/td][td] Netto[/td][td] Fee[/td][/tr]


[tr][td]

2​

[/td][td] Neo A[/td][td]

900​

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


[tr][td]

3​

[/td][td] Neo A[/td][td]

200​

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


[tr][td]

4​

[/td][td] Neo A[/td][td]

500​

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


[tr][td]

5​

[/td][td] Aportase B[/td][td]

700​

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


[tr][td]

6​

[/td][td] Aportase B[/td][td]

800​

[/td][td] -[/td][/tr]
[/table]

Sheet2

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

A​

[/td][td]

B​

[/td][td]

C​

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

1​

[/td][td] Name[/td][td] Netto[/td][td] Fee[/td][/tr]


[tr][td]

2​

[/td][td] Aportase B[/td][td] -[/td][td] 5[/td][/tr]


[tr][td]

3​

[/td][td] Neo A[/td][td] -[/td][td] 10[/td][/tr]


[tr][td]

4​

[/td][td] Neo A[/td][td] -[/td][td] 90[/td][/tr]


[tr][td]

5​

[/td][td] Aportase B[/td][td] -[/td][td] 30[/td][/tr]


[tr][td]

6​

[/td][td] Neo A[/td][td] -[/td][td] 40[/td][/tr]
[/table]

Expectation (a separate sheet here)

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

A​

[/td][td]

B​

[/td][td]

C​

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

1​

[/td][td] Name[/td][td] Netto[/td][td] Fee[/td][/tr]


[tr][td]

2​

[/td][td] Aportase B[/td][td]

800​

[/td][td]

30​

[/td][/tr]


[tr][td]

3​

[/td][td] Aportase B[/td][td]

700​

[/td][td]

5​

[/td][/tr]


[tr][td]

4​

[/td][td] Neo A[/td][td]

900​

[/td][td]

90​

[/td][/tr]


[tr][td]

5​

[/td][td] Neo A[/td][td]

500​

[/td][td]

40​

[/td][/tr]


[tr][td]

6​

[/td][td] Neo A[/td][td]

200​

[/td][td]

10​

[/td][/tr]
[/table]
<strike></strike>
Column A is given (This means: Not computed.).

In B2 of Expectation, control+shift+enter, not just enter, and copy down:

=IF($A2="","",LARGE(IF(Sheet1!$A$2:$A$6=$A2,Sheet1!$B$2:$B$6),COUNTIFS($A$2:$A2,$A2)))<strike></strike>

In C2 of Expaectation, control+shift+enter and copy down:

=IF($A2="","",LARGE(IF(Sheet2!$A$2:$A$6=$A2,Sheet2!$C$2:$C$6),COUNTIFS($A$2:$A2,$A2)))<strike></strike>

<strike></strike>