Forum Discussion
XLook Up
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.
- When I insert the formula into B2 I get an error - this function isn't valid. It is highlighting the word filter in the formula??
The FILTER function is available in Excel in Microsoft 365 and Office 2021.
Which version do you have?
I am not sure - I don't think it's the version you said. It's on my computer at my office. It works on my MAC at home. I have it saved on a flash drive. Will it work when I insert the flash drive into my computer at the office?
