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 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.