Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    Malaysia
    Posts
    7

    Red face Unanswered: Pleaseeee help me - lookup table

    hi,
    could anybody help me on this problem.. how i'm going to do a vlookup
    a Salary Table with DeductionTable and auto fill in to salary deduction field at the Salary Table

    SalaryTable

    Name Salary SalaryDeduction
    Micheal Lee $8,000
    Robert $7,500
    Dennis $4,000

    Deduction Table
    Salary Range Deduction
    $3,000 - $4,999 $500
    $5,000 - $6,999 $600
    $7,000 - $9,999 $700

    please!!!please!!! help me...TQ

  2. #2
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Re: Pleaseeee help me - lookup table

    Originally posted by ryfiz
    hi,
    could anybody help me on this problem.. how i'm going to do a vlookup
    a Salary Table with DeductionTable and auto fill in to salary deduction field at the Salary Table

    SalaryTable

    Name Salary SalaryDeduction
    Micheal Lee $8,000
    Robert $7,500
    Dennis $4,000

    Deduction Table
    Salary Range Deduction
    $3,000 - $4,999 $500
    $5,000 - $6,999 $600
    $7,000 - $9,999 $700

    please!!!please!!! help me...TQ
    Try to modify your Deduction table to this form

    SalaryGroup Salary Range Deduction
    10 $3,000 - $4,999 $500
    20 $5,000 - $6,999 $600
    30 $7,000 - $9,999 $700

    Also your Salary Table

    Name Salary SalaryGroup SalaryDeduction
    Micheal Lee $8,000 30
    Robert $7,500 30
    Dennis $4,000 10

    using a Creat table Query´, using the IFF statement


    then search this Salary Group using

    DLookup

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •