Is there a way or is there a formula which can skip certain values and only show the values you want. Bare with me
I have items in cell E6:E20 and F6:F20, and a date above both, what I need this to do is when I insert a date into J5, it looks at the dates in Column E5, and F5 and whatever the items are under those dates would show up under the date I entered in J5.
So in the example I have 11/7/2021 in cell J5, So I want the items under E5 because that's what matches my date in J5. But I do not want to include any of the Cells which say "Off, Call Off, No Show, Training.
Then Also if I enter 11/8/2021 in J5, I would want the items under F5 to populate under J5, again minus any words which say "Off, Call Off, No Show, Training.
No idea if this is possible and I know it sounds really confusing
I have items in cell E6:E20 and F6:F20, and a date above both, what I need this to do is when I insert a date into J5, it looks at the dates in Column E5, and F5 and whatever the items are under those dates would show up under the date I entered in J5.
So in the example I have 11/7/2021 in cell J5, So I want the items under E5 because that's what matches my date in J5. But I do not want to include any of the Cells which say "Off, Call Off, No Show, Training.
Then Also if I enter 11/8/2021 in J5, I would want the items under F5 to populate under J5, again minus any words which say "Off, Call Off, No Show, Training.
No idea if this is possible and I know it sounds really confusing
TestMS.xlsx | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
D | E | F | G | H | I | J | K | L | M | N | |||
3 | Example 1 | Example 2 | |||||||||||
4 | |||||||||||||
5 | 11/7/2021 | 11/8/2021 | 11/7/2021 | 11/8/2021 | |||||||||
6 | 1 | Chevy | Cord | 1 | Chevy | 1 | Cord | ||||||
7 | 2 | Ford | Paper | 2 | Ford | 2 | Paper | ||||||
8 | 3 | Mercury | Card | 3 | Mercury | 3 | Card | ||||||
9 | 4 | Nissan | Off | 4 | Nissan | 4 | Marker | ||||||
10 | 5 | Tree | Marker | 5 | Tree | 5 | Sun | ||||||
11 | 6 | Clouds | Sun | 6 | Clouds | 6 | Grass | ||||||
12 | 7 | Off | Grass | 7 | Gmc | 7 | Pipe | ||||||
13 | 8 | Call Off | No Show | 8 | Ground | 8 | Video | ||||||
14 | 9 | Gmc | Pipe | 9 | Plastic | 9 | Computer | ||||||
15 | 10 | Ground | Video | 10 | Desk | 10 | Sheet | ||||||
16 | 11 | No Show | Computer | 11 | Phone | 11 | Mouse | ||||||
17 | 12 | Plastic | Off | ||||||||||
18 | 13 | training | Sheet | ||||||||||
19 | 14 | Desk | Off | ||||||||||
20 | 15 | Phone | Mouse | ||||||||||
21 | |||||||||||||
Sheet1 |