View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default checking input in a cell and return by copying info from a other c

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

http://office.microsoft.com/en-us/ex...260381033.aspx
--
Gary''s Student - gsnu201001


"Golf-Iron7" wrote:

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.