getting data from a list!

  • Thread starter Thread starter pinmaster
  • Start date Start date
P

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
 
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)
 
Back
Top