Results 1 to 2 of 2

Thread: Lookup a unique, conditional value between two sheets

  1. #1

    Lookup a unique, conditional value between two sheets



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

    The following problem is probably simple, but I canít figure out the right function. Please help:

    Sheet 1 has the following:
    Column A, B contain non-unique numbers
    1,000 rows

    Sheet 2 has the following:
    Column A, B, C contain non-unique numbers
    Column D contains unique text IDs
    10,000 rows


    Task:
    For each row in Sheet 1 get unique text IDs from Sheet 2 that satisfies the following condition:
    Sheet 1, Column A = Sheet 2, Column A
    Sheet 1, Column B is greater than Sheet 2, Column B but less than Sheet 2, Column C

    Thank you.

  2. #2
    Super Moderator JeffreyWeir's Avatar
    Join Date
    Mar 2011
    Location
    New Zealand
    Posts
    356
    Articles
    0
    Hi Morph1. This is probably accomplished with a combination of VBA (i.e. macros) and SQL (i.e. Structured Query Language, which is used to retrieve data from databases.) If you post a file with some sample data and instructions, I'll whip up an example for you.

Tags for this Thread

Posting Permissions

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