Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-30-2019, 11:04 PM
Cero197 Cero197 is offline Mac OS X Office 2016
Novice
 
Join Date: Apr 2019
Posts: 4
Cero197 is on a distinguished road
Angry LOOKUP, IF, TODAY....I'm ready to give up

Im trying to input data from sheet1 to sheet3 on certain conditions. If today is Sunday then is want to input from sheet1 A3:A23 and that data would go to sheet3 DEFGH18EFGH40. But I wan tit contingent on the day. I've included piks...Maybe I'm brainfarting. But I've been brainfarting for days then.
Attached Files
File Type: zip Forum 2.zip (382.7 KB, 4 views)
File Type: zip Forum 3.zip (1.05 MB, 3 views)

Last edited by Pecoflyer; 04-30-2019 at 11:16 PM. Reason: Removed picture
Reply With Quote
  #2  
Old 04-30-2019, 11:14 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,386
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Hi and welcome
please post sample sheets ( click Go advanced - Manage attachments).
Pictures are nice to look at but quite useless to work with.
Thank you
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #3  
Old 05-01-2019, 11:41 PM
Cero197 Cero197 is offline Mac OS X Office 2016
Novice
 
Join Date: Apr 2019
Posts: 4
Cero197 is on a distinguished road
Default

So I think the pages may be out of order, but I think you get the jist. Let me know if there is anything Else you need
Attached Files
File Type: xlsx For Forum.xlsx (37.9 KB, 7 views)
Reply With Quote
  #4  
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: 202
NBVC 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
  #5  
Old 05-02-2019, 11:08 PM
Cero197 Cero197 is offline Mac OS X Office 2016
Novice
 
Join Date: Apr 2019
Posts: 4
Cero197 is on a distinguished road
Default

I'm thinking that I'm asking the question in the wrong way, and also am bad at making example workbooks so i'm attaching along a copy of the original.

What I'm trying to do is populate Planner D18 through D40 named "Prioritized Task List" with a list from SMITDAILY contingent on the day. So if today is Sunday I want the vertical list from SMITDAILY A3 through A23 to populate in Planner D18 through D38, however if today is Thursday, I want the vertical list from SMITDAILY E3 through E24 to populate in Planner D18 through D39. I have gotten the to populate with the given formula, however, I have to manually change the day. I would like those cells to recognize which day of the week it is and input the correct text from SMITDAILY to Planner.
Attached Files
File Type: xlsx Cero Daily Planner1.xlsx (36.9 KB, 2 views)

Last edited by Cero197; 05-02-2019 at 11:09 PM. Reason: Forgot to add attachment
Reply With Quote
  #6  
Old 05-03-2019, 04:32 AM
NBVC's Avatar
NBVC NBVC is offline Windows 10 Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 202
NBVC will become famous soon enough
Default

Try:


=INDEX(SMITDAILY!$A$3:$G$24,ROWS($D$18:$D18), MATCH(TEXT(TODAY(),"dddd"),SMITDAILY!$A$2:$G$2,0))
Reply With Quote
  #7  
Old 05-04-2019, 06:25 AM
Cero197 Cero197 is offline Mac OS X Office 2016
Novice
 
Join Date: Apr 2019
Posts: 4
Cero197 is on a distinguished road
Default

GREAT SUCCESS!!!!! Brilliant, thank you so much. Works perfectly.
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 10:34 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft