Thread: Lookup, Match?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default 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
Reply With QuoteReply With Quote