Look-up List?

colmcg

Board Regular
Joined
Jul 2, 2004
Messages
101
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.
 

Some videos you may like

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

colmcg

Board Regular
Joined
Jul 2, 2004
Messages
101
Kris, babycody. Thanks for your replies.

Kris I pasted your formula in F2 and it returns #VALUE! I'm not sure what your formula does so I don't know how to edit it.

Babycody, I tried VLookup and also HLookup but cannot get it to work. Probably down to me not referencing the correct cells in the formula. can you advise what the formula should be please.

Thanks in advance.

Colin
 

babycody

Well-known Member
Joined
Jul 8, 2003
Messages
1,395

ADVERTISEMENT

A4 contains the the data validation drop down list.
Book2
ABCDE
1apple1234
2pear5678
3
4apple1234
5
Sheet1
 

Watch MrExcel Video

Forum statistics

Threads
1,113,947
Messages
5,545,134
Members
410,663
Latest member
iilex
Top