Good day.
I have a problem with my output. (Ive attached the test file here)
Team-Test1.xlsx
B3:B6 is setup with type of cars and C2:F2 is set up with teams.
Between C3:F6 i have different weeks, and what i am trying to is that i can make a list that tells me what team i have that has the competence to handle the car in a given week.
So in my example i have also listed Week1-Week4 in H3:H6, Type of Car in I3:I6 and Team w/Competence in J3:J6.
In I3:I6 i can write what ever car i want, to be able to see in J3:J6 what teams that have the competence in the given weeks in H3:H6.
-If you take a look in the example file you can see that the code in J6 outputs the correct answer, but J3-J5 doesn't.
-There is where my problems are. (The code is something i got from another excel project that seem to be similar)
Sorry if i didn't explain myself properly
Best regards,
Noop
Bookmarks