Forum Discussion
XLook Up
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?
If you have an older version at work, the formula that I proposed won't work there.
- So, what do i need to change to get it to work on a previous version?
The short answer is: get Microsoft 365.
The longer and more complicated one:
In B2 in the Kyle workbook, enter the following formula and confirm it by pressing Ctrl+Shift+Enter to turn it into an array formula:
=IFERROR(INDEX('[PO Number System.xlsx]PO'!C$2:C$50, SMALL(IF('[PO Number System.xlsx]PO'!A$2:A$50="Kyle", ROW('[PO Number System.xlsx]PO'!A$2:A$50)-ROW('[PO Number System.xlsx]PO'!A$2)+1), ROWS($B$2:$B2))), "")
Fill down to B58.
Then do the same for the other columns, carefully checking which column in the PO Number System workbook corresponds to the column with the formula in the Kyle workbook.
Similar for the Marc workbook, with "Marc" instead of "Kyle" of course.