lookup question

[nader assaleh]

hi guys
from attached file how can i find the ID for all workers who work on SUN (this is dynamic) cell c3
in shift A ( this is also dynamic) cell c4

many thanks

 

[tomas]

this should do it

 

[nader assaleh]

thnx. works flawlessly.

is there another easier method.

 

[bosco_yip]

Another option in easier way.

Please see attachment.

Regards

 

[bines53]

It is also possible that,

Without helped Column,

Excel 2010 and above,

David

 

[bines53]

The File,

 

[nader assaleh]

is there a

The File,

thank you much. but i wonder if it could solved without using row function as i do not feel comfortable when it being used.

 

[bines53]

ROW(A1)=1,ROW(A2)=2
Look in the file,

David

 

[John Jairo V]

Hi to all!

Is better use ROWS(O$6:O6) (if the init formula is in O6) instead of ROW(A1) or ROW(1:1), 'cause if you eliminate the column A or insert new rows, the formula don't work. Blessings!

 

[bosco_yip]

Another reason in use ROWS(A$1:A1) instead of ROW(A1) or ROW(1:1) :

=ROWS(A$1:A1) --> return : 1

=ROW(A1) --> return : {1}

=ROW(1:1) --> return : {1}

Regards
Bosco