I have a sheet set up with the following;
Week 1 to Week 52 in Cells H1 to BG1
In cells H2 to BG21 data which is linked to a different workbook
Cell A24 contains a data validation list (H1 to BG1) i.e. Week 1 to Week 52
What I would like to do is select a week from the list in A24 (e.g. Week 4 which would be K1) then display the values from cells K2:K21 in cells F2:F21.
I have tried using Lookup but cannot figure out how to get it to work. I've done a search on this forum and there are lots of 'Lookup' posts but none do what I require.
Is it the Lookup function I should use or do I need to use a different function?
Your help would be gratefully appreciated.
Week 1 to Week 52 in Cells H1 to BG1
In cells H2 to BG21 data which is linked to a different workbook
Cell A24 contains a data validation list (H1 to BG1) i.e. Week 1 to Week 52
What I would like to do is select a week from the list in A24 (e.g. Week 4 which would be K1) then display the values from cells K2:K21 in cells F2:F21.
I have tried using Lookup but cannot figure out how to get it to work. I've done a search on this forum and there are lots of 'Lookup' posts but none do what I require.
Is it the Lookup function I should use or do I need to use a different function?
Your help would be gratefully appreciated.