Hi
please can you assist - I'm trying to lookup a reference and want the result as a list
Need the list in sheet1 C7. if P4 in sheet1 =1 then look up in sheet "Shift Schedule" column I and bring column G the shifts
Morning 1
Morning 2
Afternoon
Night
I know you might argue that if P4 = 2 its the same shifts but it will be different positions which we will still work on to pull that through as well
let me know if it make sense pls
Last edited by Roma1r; 06-01-2018 at 02:01 AM.
Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!
- Use concise, accurate thread titles.
- Your post title should describe your problem, not your anticipated solution.
- Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
- Responding to a request to change your thread title by doing so is mandatory.
To change a title go to your first post, click EDIT then Go Advanced and change your title.
No help to be offered, please, until the OP complies with this request.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Better - thank you.
Hi Roma1r
Hoe gaan dit daar doer in die Kaap? PE old boy here from Carletonville and Klerksdorp. now living in USA. Son lives in CT, sister in Durbs.
Looking at your file, there is very little actual data in it to go on. Seems you have a bunch of formulas referencing a file we do not have access to
...,IF(AND(N7="OnShift",C7="Day",L7>'O:\T&O\Business Support\Business Reporting & Compliance\Terminal Time Sheets\Klerksdorp\TEST\[Copy of Klerksdorp Terminal Time Sheet ...etc
can I suggest that you copy/paste values for some of those, so we have something to work with? Also maybe show some expected outcomes (and why)?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Named Range "DV_List" in "Shift Schedule"
in O6
=IFERROR(INDEX('Shift Schedule'!$F$6:$F$17,SMALL(IF('Shift Schedule'!$G$6:$G$17=Sheet1!$P$4,ROW('Shift Schedule'!$F$6:$F$17)-ROW($F$6)+1,""),ROWS($F$6:F6))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Then copy down
In Sheet1 C7
DV
=List
Source:
=DV_list
Hello
We will be testing a little later and will let you know - Thanks John
Hi Dibbins
Dit gaan nou weer beter in die Kaap vandat ons darem reen gekry het - nice chatting to you again:-)
Yes, my son told me the water restrictions had eased a bit, and you guys had some rain.
Happy to help and thanks for the feedback, let us know how you make out please
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks