Forum Discussion
marietuttle1973
Aug 08, 2024Copper Contributor
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 ...
marietuttle1973
Copper Contributor
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.
HansVogelaar
Aug 08, 2024MVP
Can you post an example of a complete formula?
- marietuttle1973Aug 08, 2024Copper Contributor=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))), "")
- HansVogelaarAug 08, 2024MVP
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))), "")
- marietuttle1973Aug 08, 2024Copper ContributorYou are awesome. Thanks so much. I guess when I was deleting the previous workbook name I went too far. Thanks again!