You can use =INDIRECT()

Look at the help for this function, but as an example if I had a function

=VLOOKUP(A1,B1:C10,2,false) and the string "B1:C10" in cell D1 I could use:

=VLOOKUP(A1,INDIRECT(D1),2,false) instead.

You will need something like

=VLOOKUP(A1,INDIRECT("\Factory Figures\Material\Daily Yield\YieldWK" & X1 &
"\" & Y1),2,false)

where X1 is your 20 or 21, and Y1 your 24AUG etc.

Sam

"Clyde Dickson" wrote:

I have a spreadsheet that looks up certain daily production figures. I would
like to update the path or create a path linked to certain cells. This is the
path \Factory Figures\Material\Daily Yield\YieldWK20\24AUG
How can I easily change THE 2 VARIABLES YIELDWK20 to 21 after 7 Days and
24AUG to 25AUG ?