return list from another sheet

08/13/18 Edited 12/09/19

Anyone able to offer some help on the formula below - trying to return a list of information relative to an employee ID number to a column.  There will be several matches per ID, e.g. Matt worked item 1..  2...  3.. and 7.  I want to return the information relative to that ID for those entries.

 

Thanks in advance!

 

=IFERROR(INDEX({Phone TESI Data Tracker - 1 Assigned Items Range 1},SMALL(IF([working column - do not modify]1={Phone TESI Data Tracker - 1 Assigned Items Range 1},ROW{Phone TESI Data Tracker - 1 Assigned Items Range 1}({Phone TESI Data Tracker - 1 Assigned Items Range 1})-2,""), ROW{Phone TESI Data Tracker - 1 Assigned Items Range 2},2)),"")

Comments

Sign In or Register to comment.