Forum Discussion
XLook Up
If you have an older version at work, the formula that I proposed won't work there.
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.
- The array formula above is returning the Customer Name to each cell in row 2. What am i supposed to be changing?
Did you confirm the formula by pressing Ctrl+Shift+Enter?