Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 5
Default If Functions For Dyanmic Drop List

Hello everyone,

Thanks for all the help that I have receievd since being a memeber. I have a 5 data validation lists on one sheet. They each have specific criteria referencing another sheet, but it only a small portion functions. I have an if formula for an hourly staffing report, that refereneces each indivual day in the week, but only works on sunday.


=IFERROR(IF('SCHEDULE WEEK ONE'!$J5="","",IF(AND(ISNUMBER(SEARCH($P$15,'SCHED ULE WEEK ONE'!$L5)),SEARCH($P$19,'SCHEDULE WEEK ONE'!$C5),SEARCH($P$23,'SCHEDULE WEEK ONE'!$E5),SEARCH($P$27,'SCHEDULE WEEK ONE'!$F5),SEARCH($P$31,'SCHEDULE WEEK ONE'!$G5)),(RIGHT('SCHEDULE WEEK ONE'!$J5,1))+0,"")),"")


I want it to pull a start shift time and end shift time to match the criteria. I have two columns that are one for start time, and end time and another thats combined. the one shown is combined. This one doesnt not pull the end shift time! Hopefully I explained this properly. Also should I use something other than data validation list?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
drop down list based on other drop down list pick Ruth Excel Discussion (Misc queries) 1 August 25th 09 04:12 PM
Drop down list dependant on previous drop down list Tenacioushail Excel Discussion (Misc queries) 1 July 1st 08 11:35 AM
Defining a Dyanmic Array in User Defined Type CK Excel Programming 4 April 11th 08 12:51 AM
multiple select from the drop down list in excel. list in one sheet and drop down in sriramus Excel Discussion (Misc queries) 5 October 27th 05 06:55 PM
dyanmic range Steve[_42_] Excel Programming 4 January 23rd 04 09:15 AM


All times are GMT +1. The time now is 03:19 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"