=IF(A1="january",A2,"not")
this will display A2 if A1 is text January,but of course you can only nest a
few ifs.Are you really only wanting to display the contents of one cell for
each month?
--
paul
remove nospam for email addy!



"Todd Nelson" wrote:

Does anyone know the formula to pull information that corresponds to the
month referred to. I am doing a review spreadsheet and need the numbers to
autofill for the corresponding month. Example. If A1=January, A2, If feb,
b2. I am stuck on this and any help would greatly be appreciated