N
nuver
Thank you Joe. I recreated your example and it works fine. I have copie
the formula into my workbook but I am not getting the results I a
looking for. Could you please take a look at my example below and le
me know what I am doing wrong.
Lookup information is located in sheet named Seattle.
Col A ColB ColC ColD
Item# Week1 Week2 Week3
1 WHITE
2 GREEN
3 BLUE
1 RED
5 ORANGE
1 BLUE
Results need to feed into a new sheet named Seattle 2 and should loo
like this
Col A ColB ColC ColD
Item# Week1 Week2 Week3
1 WHITE RED BLUE
2 GREEN
3 BLUE
5 ORANGE
What I need to achieve is to get every color for a single item liste
in the same row for the corresponding week. Your help is greatl
appreciated
the formula into my workbook but I am not getting the results I a
looking for. Could you please take a look at my example below and le
me know what I am doing wrong.
Lookup information is located in sheet named Seattle.
Col A ColB ColC ColD
Item# Week1 Week2 Week3
1 WHITE
2 GREEN
3 BLUE
1 RED
5 ORANGE
1 BLUE
Results need to feed into a new sheet named Seattle 2 and should loo
like this
Col A ColB ColC ColD
Item# Week1 Week2 Week3
1 WHITE RED BLUE
2 GREEN
3 BLUE
5 ORANGE
What I need to achieve is to get every color for a single item liste
in the same row for the corresponding week. Your help is greatl
appreciated