Lookup, Match?
 

4/2/18 4/3/18 4/4/18 4/5/18 4/6/18 4/7/18 4/8/18 4/9/18
John q q e q q w w q
Mary q q e q q w w e
William q q q q q w w e


4/4/2018
e

Help I need a formula that will look up todays date and will return ALL names that have an "e" for that day. in this case it would be

John
Mary

Lookup, Match?
 

Hi,

Am Tue, 24 Apr 2018 11:20:12 -0700 (PDT) schrieb
:

4/2/18 4/3/18 4/4/18 4/5/18 4/6/18 4/7/18 4/8/18 4/9/18
John q q e q q w w q
Mary q q e q q w w e
William q q q q q w w e

4/4/2018
e

try:
=IFERROR(INDEX(A:A,SMALL(IF(INDEX($A$1:$Z$4,,MATCH (TODAY(),$A$1:$Z$1,0))="e",ROW($1:$4)),ROW(A1)))," ")
Enter this formula with CTRL+Shift+Enter and then copy down.


Regards
Claus B.
--
Windows10
Office 2016

Lookup, Match?
 

On Wednesday, April 25, 2018 at 8:28:34 AM UTC-5, Claus Busch wrote:
Hi,

Am Tue, 24 Apr 2018 11:20:12 -0700 (PDT) schrieb
:

4/2/18 4/3/18 4/4/18 4/5/18 4/6/18 4/7/18 4/8/18 4/9/18
John q q e q q w w q
Mary q q e q q w w e
William q q q q q w w e

4/4/2018
e

try:
=IFERROR(INDEX(A:A,SMALL(IF(INDEX($A$1:$Z$4,,MATCH (TODAY(),$A$1:$Z$1,0))="e",ROW($1:$4)),ROW(A1)))," ")
Enter this formula with CTRL+Shift+Enter and then copy down.


Regards
Claus B.
--
Windows10
Office 2016

Hello Claus, Thank you for your help, does it matter what cell would I put in this formula for it to work?

Lookup, Match?
 

jaime.calderon816 wrote:

On Wednesday, April 25, 2018 at 8:28:34 AM UTC-5, Claus Busch wrote:
Hi,

Am Tue, 24 Apr 2018 11:20:12 -0700 (PDT) schrieb
:

4/2/18 4/3/18 4/4/18 4/5/18 4/6/18 4/7/18
4/8/18 4/9/18
John q q e q q w w q
Mary q q e q q w w e
William q q q q q w w e

4/4/2018
e

try:
=IFERROR(INDEX(A:A,SMALL(IF(INDEX($A$1:$Z$4,,MATCH (TODAY(),$A$1:$Z$1,0))
="e",ROW($1:$4)),ROW(A1))),"") Enter this formula with CTRL+Shift+Enter
and then copy down.

Hello Claus, Thank you for your help, does it matter what cell would I
put in this formula for it to work?

The $'s should keep the results consistent no matter where you put it. (If it
mattered, Claus would have told you. He's good like that.)

--
My father had a dream of a benevolent universe,
wherein Heaven, Purgatory, and Hell are all
necessary aspects of a Divinely functioning whole.

Lookup, Match?
 

Hi Jaime,

Am Wed, 25 Apr 2018 07:55:37 -0700 (PDT) schrieb
:

=IFERROR(INDEX(A:A,SMALL(IF(INDEX($A$1:$Z$4,,MATCH (TODAY(),$A$1:$Z$1,0))="e",ROW($1:$4)),ROW(A1)))," ")
Enter this formula with CTRL+Shift+Enter and then copy down.

Hello Claus, Thank you for your help, does it matter what cell would I put in this formula for it to work?

the date you are looking for in B10. The letter you are looking for in
B11. Then try:
=IFERROR(INDEX(A:A,SMALL(IF(INDEX($A$1:$Z$4,,MATCH ($B$10,$A$1:$Z$1,0))=$B$11,ROW($1:$4)),ROW(A1)))," ")



Regards
Claus B.
--
Windows10
Office 2016

Lookup, Match?
 

On Wednesday, April 25, 2018 at 8:28:34 AM UTC-5, Claus Busch wrote:
Hi,

Am Tue, 24 Apr 2018 11:20:12 -0700 (PDT) schrieb
:

4/2/18 4/3/18 4/4/18 4/5/18 4/6/18 4/7/18 4/8/18 4/9/18
John q q e q q w w q
Mary q q e q q w w e
William q q q q q w w e

4/4/2018
e

try:
=IFERROR(INDEX(A:A,SMALL(IF(INDEX($A$1:$Z$4,,MATCH (TODAY(),$A$1:$Z$1,0))="e",ROW($1:$4)),ROW(A1)))," ")
Enter this formula with CTRL+Shift+Enter and then copy down.

Works great thank you


Regards
Claus B.
--
Windows10
Office 2016