Results 1 to 3 of 3

Thread: Need help with a lookup of multiple criteria

  1. #1

    Need help with a lookup of multiple criteria



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I need help with a complex lookup and not sure of the best option:

    Lookup Sheet:
    Name Eff Date
    John 7/3/14

    Lookup Table
    Name Fr Date To Date %
    John 1/1/14 6/25/14 90%
    John 6/26/14 12/31/14 70%

    Formula Result: 70% (John's effective date would result in 70% since it falls within the date range of the second line for John)

    I've looked into Vlookup, Index, Match, but not finding exactly what I need. Any help would be appreciated. Thanks.

  2. #2
    Pls see the file attach, Im' givin you example based on your table, using array formula.

    Regards
    Attached Files Attached Files

  3. #3
    Or you could try an if statement:

    IF(AND(B3>=B7,B3<=C7),D7,IF(AND(B3>=B8,B3<=C8),D8,""))
    Attached Files Attached Files

Posting Permissions

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