- I'm creating a spreadsheet to track a spreadsheet that's located at http://tomato.ftpaccess.cc/shares/spreadsheets/(month)/mmmm dd, yyyy.csv. Before now I've been using a local copy [E:\Downloads\Spreadsheets\June\june 1, 2010.csv] which has worked fine. How do I use the remote file from my server?
- I also need the date updated automatically in the formula. (e.g. In column A I have the names in a table. Across row 1 I have the dates. I need the formula to pull the date info from row 1(dates) into the formula in B2:B32) I need this to work on a new spreadsheet for every month.
- The formula is =IF(ISNA(VLOOKUP($B3,'[E:\spreadsheets\july 2010\[July 1, 2010.csv]]July 1, 2010.csv]'!$A:$F,4,TRUE)),0,VLOOKUP($B3,'[E:\spreadsheets\july 2010\[July 1, 2010.csv]]July 1, 2010.csv]'!$A:$F,4,TRUE)). It never worked quite right so if you have any other solutions please let me know. I'm open to suggestions.
