Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jun 2003
    Location
    New Jersey
    Posts
    103
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Hello all,

    I have a huge file that I need to pull a target number for each employee. The problem I am having is that the value I need to pull is based on a few columns. I attached a sample of the spreadsheet for your reference. But...basically I am trying to pull a value into my employee row from a table grid. For example, If the employee is a Band F and in Personnel Subarea Home office US and Pay scale area is non-sales then pull the value from the grid pertaining to all the conditions. Can someone please help?

    Thank you!
    Attached Files Attached Files

  2. #2
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Have a look at the attached Example to see if it helps.

    [attachment=88558:Sample.xls]
    Attached Files Attached Files
    Andrew

  3. #3
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by AKW View Post
    Have a look at the attached Example to see if it helps.

    [attachment=88558:Sample.xls]
    Column E would have to be ordered "Exceeds, Meets, Needs Development" to ensure that the entries in Column A are in alphabetic order when being used for the Lookup.

  4. #4
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    Column E would have to be ordered "Exceeds, Meets, Needs Development" to ensure that the entries in Column A are in alphabetic order when being used for the Lookup.
    This is not the case!

    Since we are using VLOOKUP with a 4th argument of 0 (same as false) then it does not matter what order the Lookup list is in.
    It is only with the True 4th argument of VLOOKUP that order of the lookup reference column matters.

    IF we tried to use the standard LOOKUP Function then that would have been a different matter.

    Also IF you omit the 4th argument of VLOOKUP then it defaults to TRUE which is the Order Specific option.
    Andrew

  5. #5
    3 Star Lounger
    Join Date
    Feb 2003
    Location
    Runcorn, Cheshire, United Kingdom
    Posts
    372
    Thanks
    0
    Thanked 2 Times in 2 Posts
    Quote Originally Posted by AKW View Post
    This is not the case!

    Since we are using VLOOKUP with a 4th argument of 0 (same as false) then it does not matter what order the Lookup list is in.
    It is only with the True 4th argument of VLOOKUP that order of the lookup reference column matters.

    IF we tried to use the standard LOOKUP Function then that would have been a different matter.

    Also IF you omit the 4th argument of VLOOKUP then it defaults to TRUE which is the Order Specific option.
    Ooops, my bad. I never knew that
    .
    Live and Learn!

Posting Permissions

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