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 :

Name	Netto	Fee
Neo A	900	-
Neo A	200	-
Neo A	500	-
Aportase B	700	-
Aportase B	800	-

<tbody>
</tbody>

Sheet 2 : Name Netto Fee Aportase B - 5 Neo A - 10 Neo A - 90 Aportase B - 30 Neo A - 40 <tbody> </tbody>

<tbody>
</tbody>

Expectation's result :

Name	Netto	Fee
Neo A	900	90
Neo A	200	10
Neo A	500	40
Aportase B	700	5
Aportase B	800	30

<tbody>
</tbody>

 

[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

Row\Col	A​	B​	C​
1​	Name	Netto	Fee
2​	Neo A	900​	-
3​	Neo A	200​	-
4​	Neo A	500​	-
5​	Aportase B	700​	-
6​	Aportase B	800​	-

Sheet2

Row\Col	A​	B​	C​
1​	Name	Netto	Fee
2​	Aportase B	-	5
3​	Neo A	-	10
4​	Neo A	-	90
5​	Aportase B	-	30
6​	Neo A	-	40

Expectation (a separate sheet here)

Row\Col	A​	B​	C​
1​	Name	Netto	Fee
2​	Aportase B	800​	30​
3​	Aportase B	700​	5​
4​	Neo A	900​	90​
5​	Neo A	500​	40​
6​	Neo A	200​	10​

<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>