Where j9 is your month in the drop down. Silly me. Since you said "lookup",
I thought you wanted VLOOKUP

=INDIRECT($J$9&"!b7")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jaytee" wrote in message
...
Nope, didn't quite follow that...
If the formula is : =JUN!A1, where do I insert an INDIRECT to allow the
"JUN" to change to "OCT", for instance?

=INDIRECT(B4!A1) where B4 is the drop down box of months, and A1 is the
reference on the monthly sheet didn't work.