LOOKUP, IF, TODAY....I'm ready to give up

		Microsoft Office Forums > Microsoft Excel > Excel
LOOKUP, IF, TODAY....I'm ready to give up

05-03-2019, 04:32 AM

NBVC

Windows 10 LOOKUP, IF, TODAY....I'm ready to give up

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

Try:

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COUNTIF [criteria] + give %	Tomas4	Excel	2	12-20-2016 10:28 AM
Automatically give your document a name?	jmdraft	Word	0	11-26-2016 03:48 AM
LOOKUP - Complex lookup with 2 lookups in 1 cell	sglandon	Excel	6	05-05-2016 09:44 AM
How to design a powerpoint presentation Template Retina Ready from Windows?	fayejkhan	PowerPoint	0	10-19-2015 04:25 AM
Is it possible to loop a few intro slides until you are ready to go on with the show?	Jasonwagner2012@knights	PowerPoint	10	12-30-2014 02:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:55 PM.