#1
|
|||
|
|||
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.
Last edited by Pecoflyer; 04-30-2019 at 11:16 PM. Reason: Removed picture |
#2
|
||||
|
||||
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
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
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
|
#4
|
||||
|
||||
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;;@ |
#5
|
|||
|
|||
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. Last edited by Cero197; 05-02-2019 at 11:09 PM. Reason: Forgot to add attachment |
#6
|
||||
|
||||
Try:
=INDEX(SMITDAILY!$A$3:$G$24,ROWS($D$18:$D18), MATCH(TEXT(TODAY(),"dddd"),SMITDAILY!$A$2:$G$2,0)) |
#7
|
|||
|
|||
GREAT SUCCESS!!!!! Brilliant, thank you so much. Works perfectly.
|
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 |