V-look up?

[Byambaa]

Can someone please help, I’m working in excel 2003 and need to set up a 6 week rotation of days off. I have made my six week list in six separate columns but now need a way to display then on a new sheet; copy and paste isn’t an option can I use V-Look-up and if so how? I thank you for any advise you can give

 

[bensonsearch]

Can someone please help, I’m working in excel 2003 and need to set up a 6 week rotation of days off. I have made my six week list in six separate columns but now need a way to display then on a new sheet; copy and paste isn’t an option can I use V-Look-up and if so how? I thank you for any advise you can give

i would need more info. how are you wanting to display?, maybe a sample of the setup?