Formulas

[marietuttle1973]

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 have them saved on my computer in a folder on our dropbox.  Now my formula is not working because it's looking for my flash drive.  How do I adjust the formula to look on the dropbox and where to look?  Spreadsheets are attach for reference.  You'll notice in the individual spreadsheet for Kyle, each column the formula is looking for E:\Marie - that was my flashdrive.  How do I change that to the dropbox file?  I'm not sure what all to type in.  I know where the file is.

[#2]

@marietuttle1973 

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

[#3]

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.

[#4]

@marietuttle1973 

Can you post an example of a complete formula?

[#5]

=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))), "")

[#6]

@marietuttle1973 

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))), "")

[#7]

You are awesome. Thanks so much. I guess when I was deleting the previous workbook name I went too far. Thanks again!