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.