• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 275
  • Last Modified:

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)
  • 2
1 Solution
I suggest using the Indirect formula with a Text format of the date in cell A2. Try this:
Jenedge73Author 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)
Try adding single quotes around the sheet names, then:
[ fanpages ]IT Services ConsultantCommented:

Should $B4 be $B11 (as per your original question)?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now