Vlookup question

[BH]

I'm using the below formula to return values.

=VLOOKUP($A:$A,'2011'!$A:$Z,25,FALSE)

It works but it's specific to one cell. The worksheet needs to be updated monthly with new information. How can I get it to automatically update with the new information based on a date put into the worksheet.

For example, the above formula is returning Dec 2011 info. I need to update to return Jan 2012 info for next month without re-doing the entire formula.

 

[Jim Cone]

Replace $A:$A with the address of the cell in which you enter the date.
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Extras for Excel add-in: convenience built-in)




"BH" <[email protected]>
wrote in message
news:[email protected]...