| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
