Forum Discussion
Formula help
I have a formula that references 2 separate workbooks. The formula works in Office 365 but not the 2019 Home and Student version. Can some one help me figure out what to change to make it work in the 2019 version. Spreadsheets attached for reference. And yet, I tried CTRL+Shift+Enter.
The formula is:
=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))), "")
You entered a single array formula in B2:N2. Each column should have its own formula.
