Thread: [Solved] LOOKUP, IF, TODAY....I'm ready to give up
View Single Post
 
Old 05-02-2019, 08:37 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
  
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default
Try this formula:


=INDEX(SMITDAILY!$A$3:$G$24,ROWS($D$18:$D18), MATCH($D$4,SMITDAILY!$A$2:$G$2,0))


copied down.


To remove the 0's you can format the result cells as Custom with Type: 0;-0;;@
Reply With Quote