Matching numbers with function

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:View attachment matching numbers.xlsm
Thanks in advance.

Kind regards,
Michael.

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?

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?

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?

Bob Phillips said:

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?

Click to expand...

That's right about the years. If MAKE, MODEL and SHAPE have exact match to continue matching years.