Need Help Using WS Name in Formula

[PosseJohn]

Greetings,

Every month I import data from an external source. I save the new information on a new worksheet, giving the WS a name that incorporates the date of import, "Data 141025" for example.

I have another WS that maintains a list, that I use VLOOKUP and MATCH on the data sheet.

I would like to have a cell that I enter the date of last import, and have the formulas use that date to automatically update the information.

Cell C2 will have the date of last update.

Cells F6:800 have =MATCH(C26,'Data 141025'!$A:$A,0)

I tried using =MATCH(C6,"'Data "&TEXT(C2,"yymmdd")&"'!$A:$A",0) but receive an error.

Is there any hope?

Thank you.

[sktneer]

Try something like this......

Please Login or Register  to view this content.

Does this help?

[PosseJohn]

Ah HA! Yes, that allows me to accomplish what I intended. Thank you!

[sktneer]

You're welcome. Glad I could help.
Moreover you may also click on * (star) to Add Reputation if the solution provided helped you.