Results 1 to 5 of 5

Thread: Matching numbers with function

  1. #1

    Matching numbers with function



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

    Hi guys,

    I have to pull all correct or similar numbers from second sheet into first sheet. The main purpose of the function is compare the values from TASK sheet into columns in DB sheet and if find correct or similar matches to return numbers, delimited by comma.
    I want MAKE, MODEL and SHAPE to have exact match. Examples for year:
    1. If year range in TASK sheet is '1995-1999' as in 1 row and the range is '1995-2001' in DB sheet. I want to pull these numbers in.
    2. If year range in TASK sheet is '1995-2002' and the range is '1995-2001' in the DB sheet. Although it is out of range with 1 year, I would love to pull the numbers, too.

    Please check attached file:matching numbers.xlsm
    Thanks in advance.

    Kind regards,
    Michael.

  2. #2
    I am totally confused, if Task says 1995-1999 why do you want 1995-2001 from DB, they are not the same range? And what does Matching do if not what you want?

  3. #3
    Hey mate,

    1. This function at the moment pull exact matching numbers. That means if it is perfect match of make,model,shape and years. But I want for example the range is 1995-1999 and this is in 1995-2001 to pull the number of 1995-2001.
    2. For this as above, if range is '1995-2002' and it is out range '1995-2001' in DB, but it is almost the same to pull the number of 1995-2001.

    Do you understand what I mean?

  4. #4
    Are you saying that 1995-2001 should get included because whilst it is not exactly 1995-1999, there is an overlap? If so, would 1996-2001 get included or does one edge of the range have to match?

    And so where does MAKE, MODEL and SHAPE come into it now?

  5. #5
    Quote Originally Posted by Bob Phillips View Post
    Are you saying that 1995-2001 should get included because whilst it is not exactly 1995-1999, there is an overlap? If so, would 1996-2001 get included or does one edge of the range have to match?

    And so where does MAKE, MODEL and SHAPE come into it now?
    That's right about the years. If MAKE, MODEL and SHAPE have exact match to continue matching years.

Posting Permissions

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