I have a master worksheet with lists of data. When I enter any person's name (cell B8) from the master worksheet, I need to pull each row's data in from master (pulls in columnB by finding same value in column A as cell B8). Index function works great, but doesn't recognize the cell if multiple names in the worksheet. I used: =INDEX(master!$B$5:$B$1006, SMALL(IF($B$8=master!$A$5:$A$1006, ROW(master!$A$5:$A$1006)-MIN(ROW(master!$A$5:$A$1006))+1, ""), ROW(A1)))
The problem is this doesn't recognize the cell with all 3 persons under column A and I get an error (workbook attached)
ColumnA ColumnB
Debbie K l
Beth M m
Debbie K, Colleen W, Beth M n
Sandra B o
name typed in cell B8 (eg. Debbie K)
Bookmarks