Vlookup help!

[mrpotatohead]

Hello!

I'm a student taking I.C.T at AS Level in England, and for my project I have to design a system for an end-user who wants to have an easy to use system to check the Lottery results of a syndicate.

I'm still in the design/specification stages, but I am having trouble with a basic Vlookup that I need help with.

Below is a sheet I've called ResultsHistory - in the red box is an area I have named LottoResults.

And below is another sheet called CheckResults - I want to be able to create a combo box which lists all the dates listed in the LottoResults area of the ResultsHistory sheet, and when the user selects a date - the relative numbers for that date are shown in the boxes below...

Please tell me there is a way of doing this - if anybody can help me out with this, not only will I be eternally grateful - but I'll be a very happy man!!


Thanks guys!


- Joe[/img]

 

[PaddyD]

hi - welcome to the board!

this might help:

Book1
	A	B	C	D
1	Source
2	Date	Number1	Number2	Number3
3	1/01/2001	1	2	3
4	2/01/2001	3	4	5
5	3/01/2001	7	8	9
6	4/01/2001	10	11	12
7
8
9	Date	N1	N2	N3
10	2/01/2001	3	4	5
Sheet2

...post back if you need some explanation etc...

 

[Smitty]

Welcome to the Board!

How about something like this in D4:I4

=VLOOKUP($D$3,'Lottery Results History'!$B$4:$I$20,COLUMN()-2,FALSE)

Where D3 is the Cell Link for the Combo Box.

Hope that helps,

Smitty

 

[mrpotatohead]

Thanks PaddyD, for the welcome and assistance...

I think I'm taking it in ok... what would I add for the 'Control' settings in the Combo box?

Thanks again for all your help - much appreciated!

I'm trying to get from your example, what I should include as the formula in my sheet - I've tried putting '=VLOOKUP(ResultsHistory!$B$4,ResultsHistory!$B$4:$B$20,2,0)' - but it's come up with #REF...

Sorry I'm not very good at this... thanks for bearing with me!!


- Joe

 

[mrpotatohead]

Welcome to the Board!

How about something like this in D4:I4

=VLOOKUP($D$3,'Lottery Results History'!$B$4:$I$20,COLUMN()-2,FALSE)

Where D3 is the Cell Link for the Combo Box.

Hope that helps,

Smitty

Thanks Smitty... I'll try that now!


- Joe

 

[mrpotatohead]

Ok I've done what you suggested Smitty - and I can tell I'm making some sort of progress!

Just wondering now - what do I put in for the Input Range in the Combo Box... and also... in cell D3 (where I've put the formula) - it is displaying the date 00/01/1900 ?!?!

Hmm... any suggestions!!


Many thanks... for your help!


- Joe

 

[Smitty]

The Input Range for the Combo Box will be wherever your dates are stored. Update that and your date display will be correct too.

Smitty