Problem with LOOKUP function

[Gr0zn1]

Hello!

I would like to know if LOOKUP function is the right function for my needs.
I have let's say 5 names in a row, and 7 days of the week in a column...Then I cross out (or color or anything) if on the given day a person was present or not.
Now I would like to make a column that will printout the names of persons which were present on the given day. How can I make this work (probably with LOOKUP function)?

Thanks for your help!
Have a nice day!

Peter

 

[saisank1]

It looks like it is not possible.. but not sure again.. but if you can explain more using a table (or an image) it will be of some help...

 

[etaf]

if you use a conditional format for the colours

so if you put put say an X into a cell it will format the font and the fill colour the same - so its the same as you are doing

then you can pull across into another sheet a list of names available on certain days

 

[Gr0zn1]

OK...the table should look like this:

It doesn't matter what has to be in the cells (letter,number,color, anything). I have to find a function that will type out names if there is a mark (a letter, a number, color) in that row. It must be possible to do it, but I hoped someone allready did it and could simply explain how.

 

[etaf]

i'm sure theres a much better way to do this
but off the top of my head

=TRIM(IFERROR(INDEX(C$2,MATCH("X",$C3,0)),"")&" "&IFERROR(INDEX(D$2,MATCH("X",$D3,0)),"")&" "&IFERROR(INDEX(E$2,MATCH("X",$E3,0)),"")&" "&IFERROR(INDEX(F$2,MATCH("X",$F3,0)),"")&" "&IFERROR(INDEX(G$2,MATCH("X",$G3,0)),""))

and then add for each extra column
not a good way - as you are going to sometimes get multiple spaces next to each other
there is probably a much better VBA and maybe using sumproduct

but anyway - thats my 1st thought