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 ...
The PO Number System workbook does not contain the contract date.
Open all three workbooks.
In B2 in the Marc workbook:
=CHOOSECOLS(FILTER('[PO Number System.xlsx]PO'!$B$2:$K$50, '[PO Number System.xlsx]PO'!$A$2:$A$50="Marc", ""), 2, 3, 1, 7, 8, 9, 10, 4, 5, 6)
In B2 in the Kyle workbook:
=CHOOSECOLS(FILTER('[PO Number System.xlsx]PO'!$B$2:$K$50, '[PO Number System.xlsx]PO'!$A$2:$A$50="Kyle", ""), 2, 3, 1, 7, 8, 9, 10, 4, 5, 6)
Close the PO Number System workbook.
Excel will add the path of this workbook to the formulas.
Then save the Marc and Kyle workbooks.