Sales Reps.

Total Sales Vlookup

Rajesh Kumar ₹ 464,915.14 OK
Md. Naveed Ahmed ₹ 357,125.68 OK
Krishna Dev ₹ 897,879.03 Good
Km. Ranjita ₹ 740,945.42 Good
Ravinder Pawar ₹ 788,422.02 Good
Mohan Singh ₹ 791,532.95 Good
Chloe Young ₹ 393,813.58 OK
Kishore Kumar Lalit ₹ 928,521.70 Good
Jacquelyn Suarez ₹ 96,877.41 OK
Rajan Kishore ₹ 273,310.20 OK
Elizabeth Johnson ₹ 63,820.33 OK
Smith Jane ₹ 84,068.86 OK
Shannon Carlson ₹ 127,888.06 OK
Christy Zhu ₹ 458,711.40 OK
Eugene Huang ₹ 645,187.49 Good

0 OK
500001 Good

0 500001
OK Good
 2021-O365
HLOOKUP Vlookup HLOOKUP Xlookup - V Xlookup - H
OK Abv Avg Abv Avg Abv Avg Abv Avg
OK Abv Avg Abv Avg Abv Avg Abv Avg
Good Best Best Best Best
Good good good good good
Good good good good good
Good good good good good
OK Abv Avg Abv Avg Abv Avg Abv Avg
Good Best Best Best Best
OK Low Low Low Low
OK Low Low Low Low
OK Low Low Low Low
OK Low Low Low Low
OK Low Low Low Low
OK Abv Avg Abv Avg Abv Avg Abv Avg
Good good good good good

0 Low 0%
Vlookup 300000 Abv Avg 1%
500000 good 2%
800001 Best 3%

Hlookup
0 300000 500000
Low Abv Avg good
0% 1% 2%
 Iserror

₹ 4,649.15
₹ 3,571.26
₹ 26,936.37
₹ 14,818.91
₹ 15,768.44
₹ 15,830.66
₹ 3,938.14
₹ 27,855.65
₹ 0.00
₹ 0.00
₹ 0.00
₹ 0.00
₹ 0.00
₹ 4,587.11
₹ 12,903.75

800001
Best
3%
 Operation

Emp_Code Name Department Date Hired

A001 Rob Verhoff Sales 7/11/2000
A002 Shadow Elizabeth Operation 12/1/2000
A003 Ian Jenkins Finance 4/22/2001
A004 Shila Rani Operation 5/31/2001
A005 Ruben Torres Management 8/14/2002
A006 Marco Mehta IT 2/11/2003
A007 Mohit Dhinghra Operation 2/22/2004
A008 Tom Brown Production 3/8/2004
A009 Janet Alvarez Finance 4/19/2004
A010 Lauren Walker Production 6/25/2004
A011 Gurmeet Singh Marketing 7/17/2004
A012 Vinod Adwani Production 10/31/2004
A013 Jon Yang Marketing 3/6/2005
A014 Sydney Bennett Sales 11/22/2005
A015 Julio Ruiz Finance 5/29/2006
A016 Rajesh Kumar IT 9/8/2006
A017 Md. Naveed Ahmed Production 12/24/2006
A018 Krishna Dev Sales 2/9/2007
A019 Km. Ranjita Sales 4/30/2007
A020 Ravinder Pawar Production 12/8/2007
A021 Mohan Singh Marketing 1/3/2008
A022 Chloe Young Sales 8/22/2008
A023 Kishore Kumar Lalit Management 1/29/2009
A024 Jacquelyn Suarez IT 2/4/2009
A025 Rajan Kishore Management 2/14/2010
A026 Elizabeth Johnson Finance 12/19/2010
A027 Smith Jane Production 3/16/2011
A028 Shannon Carlson Marketing 8/21/2011
A029 Christy Zhu IT 11/21/2012
A030 Eugene Huang Production 3/31/2013
A031 Rajiv Kalra Marketing 5/21/2013
A032 Sharvana Jain Sales 6/7/2013
A033 Curtis Lu Finance 7/8/2013
A034 Rajkumar Verma Management 5/9/2014
A035 Rajkishor Gupta Management 2/11/2015
A036 Chinmay Singh Finance 9/1/2015
A037 Potter Betty Operation 9/14/2015
A038 Sonu Baweja Finance 9/20/2015
A039 Doe John Management 8/27/2016
A040 Vibhore Sharma Sales 12/16/2016
A002 Department
3 3

Location Country Gender Joining Year Office Type

Victoria Australia Female 2000 Nodal Branch
Tasmania Australia Female 2000 Nodal Branch
Oregon United States Female 2001 Nodal Branch
Kolkata India Female 2001 Head Office
Tasmania Australia Female 2002 Zonal
Victoria Australia Female 2003 Zonal
Delhi India Male 2004 Head Office
California United States Male 2004 Nodal Branch
New South Wales Australia Female 2000 Head Office
Washington United States Female 2000 Head Office
Delhi India Male 2004 Nodal Branch
Kolkata India Male 2004 Head Office
Queensland Australia Female 2005 Nodal Branch
Washington United States Female 2005 Head Office
Queensland Australia Female 2006 Nodal Branch
Delhi India Male 2006 Head Office
Kolkata India Male 2006 Zonal
Kolkata India Male 2007 Head Office
Mumbai India Female 2007 Nodal Branch
Mumbai India Male 2007 Head Office
Delhi India Male 2008 Head Office
California United States Female 2008 Zonal
Delhi India Male 2009 Zonal
Queensland Australia Female 2009 Zonal
Mumbai India Male 2010 Head Office
New South Wales Australia Female 2010 Nodal Branch
British Columbia Canada Male 2011 Zonal
Queensland Australia Female 2011 Head Office
New South Wales Australia Female 2012 Head Office
Victoria Australia Female 2013 Head Office
Delhi India Male 2013 Head Office
Mumbai India Male 2013 Zonal
Queensland Australia Female 2013 Head Office
Kolkata India Male 2014 Head Office
Kolkata India Male 2015 Head Office
Delhi India Male 2015 Head Office
British Columbia Canada Male 2015 Head Office
Delhi India Male 2015 Head Office
Washington United States Male 2016 Nodal Branch
Delhi India Male 2016 Head Office
Monthly Sal Annual Sal
₹ 33,324.00 ₹ 399,888.00
₹ 23,694.00 ₹ 284,328.00
₹ 47,546.00 ₹ 570,552.00
₹ 18,114.00 ₹ 217,368.00
₹ 57,487.00 ₹ 689,844.00
₹ 61,355.00 ₹ 736,260.00
₹ 19,399.00 ₹ 232,788.00
₹ 19,841.00 ₹ 238,092.00
₹ 47,778.00 ₹ 573,336.00
₹ 21,602.00 ₹ 259,224.00
₹ 54,542.00 ₹ 654,504.00
₹ 19,549.00 ₹ 234,588.00
₹ 58,821.00 ₹ 705,852.00
₹ 56,762.00 ₹ 681,144.00
₹ 58,575.00 ₹ 702,900.00
₹ 41,834.00 ₹ 502,008.00
₹ 21,970.00 ₹ 263,640.00
₹ 51,939.00 ₹ 623,268.00
₹ 51,030.00 ₹ 612,360.00
₹ 19,429.00 ₹ 233,148.00
₹ 37,815.00 ₹ 453,780.00
₹ 32,912.00 ₹ 394,944.00
₹ 74,422.00 ₹ 893,064.00
₹ 58,694.00 ₹ 704,328.00
₹ 87,889.00 ₹ 1,054,668.00
₹ 58,136.00 ₹ 697,632.00
₹ 21,265.00 ₹ 255,180.00
₹ 59,751.00 ₹ 717,012.00
₹ 39,823.00 ₹ 477,876.00
₹ 18,786.00 ₹ 225,432.00
₹ 53,621.00 ₹ 643,452.00
₹ 52,025.00 ₹ 624,300.00
₹ 55,708.00 ₹ 668,496.00
₹ 75,883.00 ₹ 910,596.00
₹ 63,548.00 ₹ 762,576.00
₹ 44,559.00 ₹ 534,708.00
₹ 17,212.00 ₹ 206,544.00
₹ 57,994.00 ₹ 695,928.00
₹ 62,120.00 ₹ 745,440.00
₹ 54,778.00 ₹ 657,336.00
 Emp_Code A013

Name Department Date Hired

Vlookup Jon Yang Marketing 6-Mar-05
Vlookup & Column Jon Yang Marketing 6-Mar-05
Vlookup & Sequence #NAME? #NAME? #NAME?
Xlookup Jon Yang Marketing 6-Mar-05
Xlookup #NAME? #NAME? #NAME?

Match 4 8 7
Date Hired Joining Year Gender
Index & Match 6-Mar-05 2005 Female
Vlookup & Match 6-Mar-05 2005 Female
 Location Country Gender Joining Year Office Type Monthly Sal
Queensland Australia Female 2005 Jon Yang Jon Yang
Queensland Australia Female 2005 Nodal Branch ₹ 58,821.00
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME?
Queensland Australia Female 2005 Nodal Branch ₹ 58,821.00
#NAME? #NAME? #NAME? #NAME? #NAME? #NAME?

6 10 11 2
Country Monthly Sal Annual Sal Name
Australia 58821 705852 Jon Yang
Australia 15-Jan-61 21-Jul-32 Jon Yang
 Annual Sal
Jon Yang
₹ 705,852.00
#NAME?
₹ 705,852.00
#NAME?