Problem with LOOKUP function

Gr0zn1

New Member
Joined
Jan 28, 2014
Messages
2
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
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

saisank1

New Member
Joined
Jan 20, 2014
Messages
3
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

Well-known Member
Joined
Oct 24, 2012
Messages
4,426
Office Version
  1. 365
Platform
  1. MacOS
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

New Member
Joined
Jan 28, 2014
Messages
2
OK...the table should look like this:
tabela.png


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

Well-known Member
Joined
Oct 24, 2012
Messages
4,426
Office Version
  1. 365
Platform
  1. MacOS
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
 

Watch MrExcel Video

Forum statistics

Threads
1,123,385
Messages
5,601,331
Members
414,446
Latest member
CRAVIN

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top