Hi,

is it possible to use the value from a cell as the sheet name in a VLOOKUP
function?

for example, the formula is -
=VLOOKUP(A17,[Book1]August09!$A$1:$E$11,2,FALSE). In this formula, the
"August09" part is the one that I want to be able to select in a dropdown.
Whatever month I select in the dropdown, the formula should take the data
from the sheet named as the one I selected.

any help would be appreciated.

Thanks