getting data from a list!

[pinmaster]

Here's what I have. In G3 I have a formula that counts the number o
weeks that have been entered, and in B2:B37 from the Lists Sheet I hav
a list of events. Now what I want to do is get the event tha
correspond with the number of weeks! example: if G3=3 then get the 3r
entry from the list!

Jean-Guy
Canad

 

[Bob Phillips]

Morning Jean-Guy,

This should do it

=INDEX(B2:B37,G3,1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[pinmaster]

Hi Bob, perfect, just what I wanted!

thanks a million!

Jean-Guy Collette
Canad