[Guntars]

For example I got this simple table:
___________one___two___three
Name 1______X___________X_
Name 2______X_____X_______
Name 3____________X_______
Name 4______X___________X_
Name 5______X_____X_______
Name 6__________________X_
Name 7______X_____________
Name 8______X_____X_____X_
Name 9____________X_______

How do I tell formula to return all the names from col A:A if the column
€œthree€� has €œX€� in name row?
Thank you
Guntars

[Jacob Skaria]

If you dont have duplicate names.. try the below

in E2
=INDEX(A1:A1000,MATCH("x",$D$1:$D$1000,0))

in E3 and subsequent rows
=INDEX($A$1:$A$1000,MATCH("x",INDIRECT("D"&MATCH(E 2,$A$1:$A$1000,0)+1 &
":D1000"),0)+MATCH(E2,$A$1:$A$1000,0))

If this post helps click Yes
---------------
Jacob Skaria


"Guntars" wrote:

For example I got this simple table:
___________one___two___three
Name 1______X___________X_
Name 2______X_____X_______
Name 3____________X_______
Name 4______X___________X_
Name 5______X_____X_______
Name 6__________________X_
Name 7______X_____________
Name 8______X_____X_____X_
Name 9____________X_______

How do I tell formula to return all the names from col A:A if the column
€œthree€� has €œX€� in name row?
Thank you
Guntars