Hi,
I have a problem. I have a workbook with two worksheets.
Below is a link to the file is you want to see it in IRL.
https://www.dropbox.com/s/xhniqhd1j1lxny7/Range%20schedule%20mrexcel.xlsx?dl=0
What I want to achieve is to select "Product area" and "SSD" on worksheetA.
Based on the selected criterias on worksheetA, get the data from WorksheetB and print this in cell B5:F5 and if there are multiple matches paste this data to B6:F6 and so on.
The SSD date in worksheetA should be correlate to the date in the SSD and SED in worksheet B, hower some dates in SED are infinite∞ and I'm not sure you can have infinite as an end date in search criteria?
I was thinking of using countifs to count how many rows maches the criteria on worksheet A. The formula for this is below and would be pasted into cell F2 on worksheet A.
=COUNTIFS(SheetB!$H$2:$H$11,$C$2,SheetB!$M$2:$M$11,"=>"&$E$2,SheetB!$N$2:$N$11,"=<"&$E$2)
and the perhaps a nested IF with index and match get the data from worksheetB.
But I am dead stuck I believe that there must be an easier way to get around this. Also of if the infinite is not possible I will change these to actual dates.
I have a problem. I have a workbook with two worksheets.
Below is a link to the file is you want to see it in IRL.
https://www.dropbox.com/s/xhniqhd1j1lxny7/Range%20schedule%20mrexcel.xlsx?dl=0
What I want to achieve is to select "Product area" and "SSD" on worksheetA.
Based on the selected criterias on worksheetA, get the data from WorksheetB and print this in cell B5:F5 and if there are multiple matches paste this data to B6:F6 and so on.
The SSD date in worksheetA should be correlate to the date in the SSD and SED in worksheet B, hower some dates in SED are infinite∞ and I'm not sure you can have infinite as an end date in search criteria?
I was thinking of using countifs to count how many rows maches the criteria on worksheet A. The formula for this is below and would be pasted into cell F2 on worksheet A.
=COUNTIFS(SheetB!$H$2:$H$11,$C$2,SheetB!$M$2:$M$11,"=>"&$E$2,SheetB!$N$2:$N$11,"=<"&$E$2)
and the perhaps a nested IF with index and match get the data from worksheetB.
But I am dead stuck I believe that there must be an easier way to get around this. Also of if the infinite is not possible I will change these to actual dates.
