Forum Discussion
Formulas
I have 3 workbooks in Excel. I have a Master PO Number Spreadsheet and a spreadsheet for each of my project managers. I was originally working on these and had them saved to my flash drive. Now I ...
You'll have to replace the path E:\Marie with the path of your local Dropbox folder. On my computer it looks like
C:\Users\<username>\Dropbox
This is the path directly to the file. When I replace it with this, I get an error
Path to location of files
C:\Users\Maura\J&M Commercial Dropbox\Sales and Bid Documents\TEST\
Error:
Excel found a problem with one or more formula references in this worksheet.
Path to location of files
C:\Users\Maura\J&M Commercial Dropbox\Sales and Bid Documents\TEST\
Error:
Excel found a problem with one or more formula references in this worksheet.
Can you post an example of a complete formula?
- =IFERROR(INDEX('C:\Users\Maura\J&M Commercial Dropbox\Sales and Bid Documents\TEST\PO Number System.xlsx]PO'!D$2:D$50, SMALL(IF('C:\Users\Maura\J&M Commercial Dropbox\Sales and Bid Documents\TEST\[PO Number System.xlsx]PO'!B$2:B$50="Marc", ROW('C:\Users\Maura\J&M Commercial Dropbox\Sales and Bid Documents\TEST\[PO Number System.xlsx]PO'!A$2:A$50)-ROW('C:\Users\Maura\J&M Commercial Dropbox\Sales and Bid Documents\TEST\[PO Number System.xlsx]PO'!D$2)+1), ROWS($D$2:$D2))), "")
You missed the [ before the first occurrence of the workbook name:
=IFERROR(INDEX('C:\Users\Maura\J&M Commercial Dropbox\Sales and Bid Documents\TEST\[PO Number System.xlsx]PO'!D$2:D$50, SMALL(IF('C:\Users\Maura\J&M Commercial Dropbox\Sales and Bid Documents\TEST\[PO Number System.xlsx]PO'!B$2:B$50="Marc", ROW('C:\Users\Maura\J&M Commercial Dropbox\Sales and Bid Documents\TEST\[PO Number System.xlsx]PO'!A$2:A$50)-ROW('C:\Users\Maura\J&M Commercial Dropbox\Sales and Bid Documents\TEST\[PO Number System.xlsx]PO'!D$2)+1), ROWS($D$2:$D2))), "")
