# Referencing a sheet via cell

I want to  set up a vlookup within a workbook and I want to be able to pick my worksheet based on a date in cell A2.  The range will always be the same but the worksheet I am referencing will be dynamic based on the date in A2.  this is the formula +IFERROR(VLOOKUP(E\$3,'16-Jun-2013'!\$B\$31:\$O\$78,MATCH(\$B11,'16-Jun-2013'!\$B\$3:\$O\$3,0),0),0)
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
I suggest using the Indirect formula with a Text format of the date in cell A2. Try this:
=IFERROR(VLOOKUP(E\$3,INDIRECT(TEXT(A2,"dd-mmm-yyyy")&"!\$B\$31:\$O\$78",MATCH(\$B11,INDIRECT(TEXT(A2,"dd-mmm-yyyy")&"!\$B\$3:\$O\$3",0),0),0)
0
Author Commented:
All my worksheets are named DD-MMM-YYYY and in cell A2 I have a date.  I had to add parentheses to the formula however I keep getting a Ref error any ideas?=VLOOKUP(E\$3,INDIRECT(TEXT(A2,"dd-mmm-yyyy")&"!\$B\$31:\$O\$78"),MATCH(\$B4,INDIRECT(TEXT(A2,"dd-mmm-yyyy")&"!\$B\$3:\$O\$3"),0),0)
0
Commented:
Try adding single quotes around the sheet names, then:
=VLOOKUP(E\$3,INDIRECT("'"&TEXT(A2,"dd-mmm-yyyy")&"'!\$B\$31:\$O\$78"),MATCH(\$B4,INDIRECT("'"&TEXT(A2,"dd-mmm-yyyy")&"'!\$B\$3:\$O\$3"),0),0)
0

Experts Exchange Solution brought to you by