Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Formula: Return 1st match, then 2nd match, then 3rd match | Excel Discussion (Misc queries) | |||
match or lookup | Excel Worksheet Functions | |||
Lookup, Match, something like this | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions |