Forum Discussion
XLook Up
I have 3 workbooks. One called PO number system and one for each project manager. Workbook 1 - PO Number system Workbook 2 - Marc Workbook 3 - Kyle On the PO Number System, Column A is dropdown ...
From the new discussion where you attached the files: you entered a single formula across the columns. Each column should have its own formula.
You were such a great help on my issues above. I have 1 final question. On the individual person's spreadsheet, I added another tab. Their sheets now have a tab called Bid Log and one called Sales Log 2024. Where in the formula do I add the name of the sheet where the formulas need to return the value to?
The current formula reads:
=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))), "")
How do I tell it to return it to Marc's workbook, Sheet called Sales Log 2024
The current formula reads:
=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))), "")
How do I tell it to return it to Marc's workbook, Sheet called Sales Log 2024