asmall4627
New Member
- Joined
- Jun 9, 2015
- Messages
- 3
Hi, I posted this earlier, but realized my title was a bit confusing.
I'm attempting to make a schedule where Objects 1-30 in Column A have predicted inspection dates in an array G2:P:31, with possibly overlapping dates of inspection. I wanted to see if I could use INDEX MATCH to search and find specific dates within the array and return the corresponding Object that must be inspected on that date, which I want to place into separate sheets for each month of the year. Essentially, am I able to use INDEX MATCH to search multiple columns for a date, and return a value that is in a single column to the left of those dates?
I've listed an example below:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Objects[/TD]
[TD]Class[/TD]
[TD]Initial Date[/TD]
[TD]Predicted Dates[/TD]
[TD]Predicted Dates Cont.[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]2[/TD]
[TD]5/5/15[/TD]
[TD]6/6/15[/TD]
[TD]7/7/15[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]3[/TD]
[TD]5/13/15[/TD]
[TD]7/13/15[/TD]
[TD]9/13/15[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]2[/TD]
[TD]5/7/15[/TD]
[TD]8/7/15[/TD]
[TD]11/7/15[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]2[/TD]
[TD]5/7/15[/TD]
[TD]8/7/15[/TD]
[TD]11/7/15[/TD]
[/TR]
</tbody>[/TABLE]
So I'd like to write a function that looks at the array from below the 1st "Predicted Dates" column to the end of the 2nd "Predicted Dates" column and returns the specific Object that corresponds to that date, which can then be placed into another sheet that lists every day in column A, with the Object to be inspected in column B next to the date, and then any other concurrent Object that is also scheduled for that date being either concatenated with the 1st value or being placed in column C next to the previous value.
I know that's a lot, but I was just hoping to see if I could get any insight or feedback.
Thank you in advance!
I'm attempting to make a schedule where Objects 1-30 in Column A have predicted inspection dates in an array G2:P:31, with possibly overlapping dates of inspection. I wanted to see if I could use INDEX MATCH to search and find specific dates within the array and return the corresponding Object that must be inspected on that date, which I want to place into separate sheets for each month of the year. Essentially, am I able to use INDEX MATCH to search multiple columns for a date, and return a value that is in a single column to the left of those dates?
I've listed an example below:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Objects[/TD]
[TD]Class[/TD]
[TD]Initial Date[/TD]
[TD]Predicted Dates[/TD]
[TD]Predicted Dates Cont.[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]2[/TD]
[TD]5/5/15[/TD]
[TD]6/6/15[/TD]
[TD]7/7/15[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]3[/TD]
[TD]5/13/15[/TD]
[TD]7/13/15[/TD]
[TD]9/13/15[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]2[/TD]
[TD]5/7/15[/TD]
[TD]8/7/15[/TD]
[TD]11/7/15[/TD]
[/TR]
[TR]
[TD]D[/TD]
[TD]2[/TD]
[TD]5/7/15[/TD]
[TD]8/7/15[/TD]
[TD]11/7/15[/TD]
[/TR]
</tbody>[/TABLE]
So I'd like to write a function that looks at the array from below the 1st "Predicted Dates" column to the end of the 2nd "Predicted Dates" column and returns the specific Object that corresponds to that date, which can then be placed into another sheet that lists every day in column A, with the Object to be inspected in column B next to the date, and then any other concurrent Object that is also scheduled for that date being either concatenated with the 1st value or being placed in column C next to the previous value.
I know that's a lot, but I was just hoping to see if I could get any insight or feedback.
Thank you in advance!