Lookup help needed
Didnt mean to duplicate the question, got the €śservice unavailable€ť error
message, and didnt know that message actually got posted.
The result I need to return in different work book, filtering wouldnt work.
"Teethless mama" wrote:
First, be patient
Second, use AutoFilter on column three
"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
|