Need Vlookup help with indirect and concatenate

[rcpalmer]

I researched that you can use indirect and concatenate to come up with the worksheet name you are trying to reference but I can't get it right....here is the formula I need adjusted

=VLOOKUP(T20,'OKC08-08-11'!$A$32:$B$37,2,FALSE)

Where OKC08-08-11 is will change daily as I create a new copy of that sheet everyday with updated information. I will rename that tab OKC08-09-11, etc. I want to reference that sheet with

concatenate("OKC",p3)

where p3 =text(today(),"mm-dd-yy")

Any help with the vlookup above would be appreciated

 

[Jonmo1]

Try

=VLOOKUP(T20,INDIRECT("'OKC" & TEXT(TODAY(),"mm-dd-yy") & "'!$A$32:$B$37"),2,FALSE)


Hope that helps.

 

[rcpalmer]

I get a #ref error....not sure what I am doing wrong here...

 

[rcpalmer]

Never mind got it to work...thanks a bunch..

I was so worried about the lookup formula...forgot to create the tab for 08-09-11!!!