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 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))), "")
You are awesome. Thanks so much. I guess when I was deleting the previous workbook name I went too far. Thanks again!