Can I name tabs with dates, reference them in cells, and INCREMENT DATE while copying?

[CaneRivero]

I have labeled my sheets tabs in the format 01Jan13, 02Jan13, etc.

The formula works, but when I try to copy it across the date doesn't increment.

(Each of my columns is labeled the same as the sheets and I want the columns to reference the correct sheet.)

=IFERROR(VLOOKUP($J3,'01Jan13'!$F$4:$G$250,2,0),"")

I'm THINKING the date (in the formula) is seen as text.

I'm open to whatever changes I need to make.

Regards,
Cane

[Richard Buttrey]

Hi,

Assuming your sheet names are in A1,B1,.....etc. then

=IFERROR(VLOOKUP($J3,INDIRECT("'"&A1&"'!$F$4:$G$250"),2,0),"")

Note that A1, B1 etc need to be text. i.e. '01Jan13'. If you simply enter 01Jan13 then Excel is likely to default that to be a date number 41275.

Alternatively if your sheet name column headers are indeed date numbers then you could use

=IFERROR(VLOOKUP($J3,INDIRECT("'"&TEXT(A1,"ddmmmyy")&"'!$F$4:$G$250"),2,0),"")

[CaneRivero]

Hello Richard-

Thank you for your answer and your kind attention.

Second Method worked!!! Many thanks!

Best regards,
Cane