Selecting a worksheet based on cell value

[croix]

I am trying to automatically select data from a different sheet to fill data in a cell based on two other cells. I've attached a simplified version of what I'm trying to do (with detailed explanations). I hope it has enough info to get my point across.

I posted this in the "programming" forum because I'm pretty sure I will need to use vba in some form or fashion to get this to work. I am more familiar with access than excel, so I may be missing some easier way to make excel do this.

Thanks,

[JBeaucaire]

This is a bit of stretch to get there, but it works. Had to adjust the SheetNames to match the format of the Date cells, too.

=INDEX(INDIRECT("'"&TEXT(C5,"MMMM YYYY")&"'!B2:B10"),MATCH($A$3,INDIRECT("'"&TEXT(C5,"MMMM YYYY")&"'!a2:a10"),0))
...copied across.

[croix]

JB - thanks! This should work just fine.

[JBeaucaire]

Great!

If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]