Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2007
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hello

    I'm trying to lookup and return a value but based on two conditions being
    satisfied.
    I key a code into A21 and a Length into F21 and return a value from the
    lookup table.
    So: If A21 and F21 are found in the lookup table then return the value in
    R4:R158
    Similarly, if A21 and H21 are found return the value.

    I've attached a piece of the spreadsheet that I hope will help explain

    Many thanks for taking the time

    Rob
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts
    The easiest way to do this is to add an extra column to your table, which has the full key you need to match.

    I have added a hidden column O, which simply contains =P4&R4 dragged down the column.
    I then changed your VLOOKUP to =VLOOKUP(A21&F21,O$3:S$200,5,FALSE)

    [attachment=83099:Write_Off_Sheet_v2.xls]
    Attached Files Attached Files

  3. #3
    New Lounger
    Join Date
    May 2007
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='StuartR' post='767727' date='27-Mar-2009 08:17']The easiest way to do this is to add an extra column to your table, which has the full key you need to match.

    I have added a hidden column O, which simply contains =P4&R4 dragged down the column.
    I then changed your VLOOKUP to =VLOOKUP(A21&F21,O$3:S$200,5,FALSE)

    [attachment=83099:Write_Off_Sheet_v2.xls]
    [/quote]


    I knew it had something to do with the Ampersand! Thanks Stu. you de man!

Posting Permissions

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