vlookup

[Narend]

Sales Person





No. Customers





Net Sales





Profit / Loss
Joseph
8
100
563
John
8
200
397
Josh
8
300
753
Jamie
9
400
923
Jackie
10
500
579
Johnson
10
600
570
Jonathan
7
700
428
Jagjit
7
800
709
Jairam
8
900
621
Jessy
6
1000
236
Javed
9
1100
966
Jimmy
6
1200
221
Juno
9
1300
1023
Respected genious according to above data how to find (who made more sales Jamie or Jackie?)

Regards
Narendra

 

[Faseeh]

Can you upload this in a sample file??

 

[Somendra Misra]

It is not very clear.You are saying which have max sales Jamie or Jackie? But they have net sales of 400 and 500 respectively. On what basis you asked for those names?

Regards,

 

[Narend]

Thanks for responding.
But answer should be with proper vlookup use.

Pls find the attachment

Thanks
Narendra

 

[Somendra Misra]

@Narend

You did not answered my question? Why the question is asking among Jamie & Jackie?

Regards,

 

[Narend]

@Narend

You did not answered my question? Why the question is asking among Jamie & Jackie?

Regards,

Yes ofcourse Somendra sir!
Because I am unable to find it with the help of vlookup formula, Like maximum and minimum etc.

thanks

yours truly
Narendra

 

[Somendra Misra]

I suppose by max sales you means max of net sales column?

Regards,

 

[Narend]

Ofcourse

regards
narendra

 

[Somendra Misra]

See this file, yellow cells in front of questions have the solution. Cross check them

Regards,