Scribd Logo
Upload

Welcome to Scribd!

  • 81 views

    Specialized Lookup Examples

    Uploaded by

    Dreamer_Shopno
    The document contains a list of 11 employee names and their corresponding employee numbers. It provides basic identifying information for each employee, including their name and employee number. The list appears to be for an organization to track their employees by name and assigned number.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd

    Specialized Lookup Examples

    Uploaded by

    Dreamer_Shopno
    81 views16 pages
    The document contains a list of 11 employee names and their corresponding employee numbers. It provides basic identifying information for each employee, including their name and employee number. The list appears to be for an organization to track their employees by name and assigned number.

    Original Description:

    Excel Formulas

    Original Title

    specialized lookup examples

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document contains a list of 11 employee names and their corresponding employee numbers. It provides basic identifying information for each employee, including their name and employee number. The list appears to be for an organization to track their employees by name and assigned number.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    81 views16 pages

    Specialized Lookup Examples

    Uploaded by

    Dreamer_Shopno
    The document contains a list of 11 employee names and their corresponding employee numbers. It provides basic identifying information for each employee, including their name and employee number. The list appears to be for an organization to track their employees by name and assigned number.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 16

    Employee No.

    : 1101 Employee Number Employee Name


    Employee Name: Melinda Hindquest 873 Charles K. Barkley
    1109 Francis Jenikins
    1549 James Brackman
    1334 Linda Harper
    1643 Louise Victor
    1101 Melinda Hindquest
    1873 Michael Orenthal
    983 Peter Yates
    972 Sally Rice
    1398 Walter Franklin
    At Bats Average Player Player to lookup: Hardy
    12 0.333 Albertson
    41 0.390 Darvin Average 0.300 <-- LOOKUP
    24 0.333 Deerberg At Bats: 30 <-- LOOKUP
    25 0.160 Gomez
    23 0.217 Gonzolez Average 0.300 <-- INDEX and MATCH
    30 0.300 Hardy At Bats: 30 <-- INDEX and MATCH
    0 0.000 Henderson
    51 0.333 Jackson
    43 0.186 King
    36 0.139 Klorber
    9 0.333 Mazden
    16 0.313 Mendez
    44 0.341 Nester
    14 0.286 Perez
    28 0.321 Talisman
    Word DOG Range1 Range2
    Result: 300 APPLE 100
    apple 200
    DOG 300
    dog 400
    CANDY 500
    candy 600
    Comm.
    Sales Rep Years Sales Commission <3 Years Tenure 3+ Years Tenure
    Rate
    Benson 2 120,000 7.00% 8,400 Amt Sold Rate Amt Sold
    Davidson 1 210,921 7.00% 14,764 0 1.50% 0
    Ellison 1 100,000 7.00% 7,000 5,000 3.25% 50,000
    Gomez 2 87,401 6.00% 5,244 10,000 3.50% 100,000
    Hernandez 6 310,983 9.25% 28,766 20,000 5.00% 200,000
    Kelly 3 43,902 2.00% 878 50,000 6.00% 300,000
    Martin 2 121,021 7.00% 8,471 100,000 7.00% 500,000
    Oswald 3 908 2.00% 18 250,000 8.00%
    Reginald 1 0 1.50% 0
    Veras 4 359,832 9.25% 33,284
    Wilmington 4 502,983 10.00% 50,298
    3+ Years Tenure

    Rate
    2.00%
    6.25%
    7.25%
    8.25%
    9.25%
    10.00%
    Student Score Grade Score Grade Alternate-1 Alternate-2
    Adams 36 F 0 F F F
    Baker 68 D 40 D D D
    Camden 50 D 70 C D D
    Dailey 77 C 80 B C C
    Gomez 92 A 90 A A A
    Hernandez 100 A A A
    Jackson 74 C C C
    Maplethorpe 45 D D D
    Paulson 60 D D D
    Ramirez 89 B B B
    Sosa 99 A A A
    Thompson 91 A A A
    Wilson 59 D D D
    Alternate-3
    F
    D
    D
    C
    A
    A
    C
    D
    D
    B
    A
    A
    D
    Course Credit Hrs Grade Grade Val Weighted Val GradeTable
    Psych 101 3 A 4 12 A 4
    PhysEd 2 C 2 4 B 3
    PoliSci 101 4 B 3 12 C 2
    IndepStudy 1 A 4 4 D 1
    IntroMath 3 A 4 12 F 0

    GPA: 3.38 <-- Requires multiple formulas and lookup table

    3.38 <--Array formula


    Month: July Widgets Sprockets Snapholytes
    Product: Sprockets January 2,892 1,771 4,718
    February 3,380 4,711 2,615
    Month Offset: 8 March 3,744 3,223 5,312
    Product Offset: 3 April 3,221 2,438 1,108
    Sales: 3,337 May 4,839 1,999 1,994
    June 3,767 5,140 3,830
    July 5,467 3,337 3,232
    Single-formula --> 3,337 August 3,154 4,895 1,607
    September 1,718 2,040 1,563
    October 1,548 1,061 2,590
    November 5,083 3,558 3,960
    December 5,753 2,839 3,013
    Total 44,566 37,012 35,542
    Combined
    9,381
    10,706
    12,279
    6,767
    8,832
    12,737
    12,036
    9,656
    5,321
    5,199
    12,601
    11,605
    117,120
    Make: Jeep Make Model Code
    Model: Grand Cherokee Chevy Blazer C-094
    Code: J-701 Chevy Tahoe C-823
    Ford Explorer F-772
    Ford Expedition F-229
    Isuzu Rodeo I-897
    Isuzu Trooper I-900
    Jeep Cherokee J-983
    Jeep Grand Cherokee J-701
    Nissan Pathfinder N-231
    Toyota 4Runner T-871
    Toyota Land Cruiser T-981
    Target: 55 Data
    Address: $C$10 74
    62
    60
    44
    50
    41
    77
    24
    55
    30
    12
    21
    7
    1
    22
    53
    36
    18
    68
    Student Data
    Ann 9,101 Target Value : 8025
    Betsy 8,873 Column Offset : -1
    Chuck 6,000
    David 9,820 Student: Leslie
    George 10,500
    Hilda 3,500
    James 12,873
    John 5,867
    Keith 8,989
    Leslie 8,000
    Michelle 1,124
    Nora 9,099
    Paul 6,800
    Peter 5,509
    Rasmusen 5,460
    Sally 8,400
    Theresa 7,777
    Violet 3,600
    Wendy 5,400
    X-value to look up: 3 x y
    1 10.00 120.00
    Matching row: 2 2 18.00
    110.00
    Exact match? 0 4 24.00
    100.00
    5 33.25
    1st row: 2 8 41.00 90.00
    2nd row: 3 9 47.00 80.00
    10 52.25 70.00
    1st x value: 2 11 61.50 60.00
    2nd x value: 4 12 72.75 50.00
    13 75.00
    40.00
    1st looked up y value: 18 15 85.00
    30.00
    2nd looked up y value: 24 16 90.00
    20 105.25 20.00
    Adjustment factor: 0.5 10.00
    Interpolated lookup: 21.00 0.00
    0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
    6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
    x-value to look up: 4 x y
    y-value: 24 1 10.00
    2 18.00
    4 24.00
    5 33.25
    8 41.00
    9 47.00
    10 52.25
    11 61.50
    12 72.75
    13 75.00
    15 85.00
    16 90.00
    20 105.25

    forecast: 25.467313

    You might also like