checking input in a cell and return by copying info from a other c

[Golf-Iron7]

What I want to do is the following. I have a worksheet in which I have
created the following; Name-Column , select-Column. I now want to created a
formula in a new sheet which check if the are "x" in the select column and
copy the names of the name-columns to cells in that new sheet. (which is in
the same workbook) is that possible? If so please let me know.

Thanks in advance.

 

[Gary''s Student]

To find a single "x" you would use VLOOKUP(). For all the "x"'s, see:

http://office.microsoft.com/en-us/excel/HA012260381033.aspx

 

[Golf-Iron7]

"Gary"s Student;

Thanks for your answer but that is not quit what I was looking for. Maybe I
need to clearly explain what I want to do.

Column B contains "x" values which have been filled in in more than one
cell. (B1;B3;B5 etc) Column A contains Names. (A1;A3;A5 etc.) And now I want
in a different worksheet in the same workbook all the valves of Column A only
if Column B is "x"

The return value needs to be one per cell. So if there are let's say 3 names
each name needs to be returned in a different cell.

I think this can't be done with formules but maybe someone has got an idea.

 

[Golf-Iron7]

Ok guys the following is the problem I really hope there is someone who can
help.

Sheet 1 contains the following.

Column A Column B
piet x
kees
jan x
joost x
etc

Sheet 2

Column A needs to show all the names in seperate cells which are marked with
a x in sheet 1.


Any idea !?!?!?!?!?!

 

[Ashish Mathur]

Hi,

Try this.

Suppose your data is in range A2:B5 on sheet1. On sheet2, type * in cell
C3. In cell D3, enter the following array formula (Ctrl+Shift+Enter) and
copy down

=IF(ISERROR(INDEX(Sheet1!$A$1:$B$5,SMALL(IF(Sheet1!$B$1:$B$7=$C$3,ROW(Sheet1!$A$1:$A$7)),ROW(Sheet1!1:1)),1)),"",INDEX(Sheet1!$A$1:$B$5,SMALL(IF(Sheet1!$B$1:$B$7=$C$3,ROW(Sheet1!$A$1:$A$7)),ROW(Sheet1!1:1)),1))

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com