Hello
I am using this formula:
=IFERROR(INDEX([43.xlsx]Who_Did_What!$E$2:$E$19000,MATCH(1,INDEX(([43.xlsx]Who_Did_What!$C$2:$C$19000=G3)*([43.xlsx]Who_Did_What!$E$2:$E$19000<>"")*([43.xlsx]Who_Did_What!$D$2:$D$19000>0)*(MMULT(([43.xlsx]Who_Did_What!$D$2:$D$19000={896,872,873,874,875,876,877,878,879,880,905})+0,{1;1;1;1;1;1;1;1;1;1})=0),0),0)),"")
You can see i am excluding values from column D in "43.xlsx",
However i've tried to add "905" to this exclusion list as you can see above, but it returns blank.
I am expecting to see GEFF
905 is an ID number for a function, not a person, i am only interested in people i.e. GEFF
I've attached both sheets used - im replicating solution to a live sheet with real data, attached is a replica
Formula is in J3 of "example 2" & I will copy this to the other yellow boxes in that column
Thank you
Bookmarks