View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Clyde Dickson[_2_] Clyde Dickson[_2_] is offline
external usenet poster
 
Posts: 1
Default Vlookup - Update Path

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 ?