Referencing Worksheet

[wiscokid]

I have the following formula
vlookup(a2,'0909'!a:b,2,false)

I would like to replace this formula with the following

vlookup(a2,'&c4&'!a:b,2,false)
where c4 = TEXT(c5,"MMDD") and c5 is the date Sep-9

It doesn't recognize the sheet 0909 in the second formula

any ideas?

 

[VoG]

Try

=VLOOKUP(A2,INDIRECT("'"&C4&"'!a:b"),2,FALSE)

 

[wiscokid]

Thank you VoG
Worked beautifully!