Hey,
I have a new excel question... every time I think I am making progress, something comes along that I just can't quite figure out. So, I'm working on a new file, I need the file to pull a number based on a date and a time. I have done both of these formulas, but I have never tried to combine them. So, basically, I am trying to get a number to automatically generate based on the date, but the number varies depending on the time of the day. So far, what I have done is create a drop down list for the times that I need, I decided that would work better than having it use the current time for various reasons based on the information I need. I have made the formula work that will allow me to pull the data I need based on the time, but I can't figure out how to get it to do it based on the date.
I'm working with two separate tabs, the main tab has the drop down list with the time. The second tab has the information I am pulling from, its a chart that has each day of the week, with a breakdown of every hour of the day, i.e.
......Sunday..........Monday..........Tuesday
12 ...XYZ. ..............ABC ...............123
1 ......ABC .............DEF ................123
2 .....GHI ..............123 ................QRS
So, I just need to be able to select 12, for example, from my drop down menu and then have the excel file automatically put the coordinating data, for example if it were Monday, ABC, in the cell.
I think I pretty much have everything else in the file working, I have some conditional formatting going, I have the date that I can use if needed, etc. this is just what I'm stuck on. I currently have it where I can pull all the data for Sunday, it's just getting the file to know what day it is and pull based on that.
I hope this all makes sense, please let me know if I need to clarify anything.
Thank you!
I have a new excel question... every time I think I am making progress, something comes along that I just can't quite figure out. So, I'm working on a new file, I need the file to pull a number based on a date and a time. I have done both of these formulas, but I have never tried to combine them. So, basically, I am trying to get a number to automatically generate based on the date, but the number varies depending on the time of the day. So far, what I have done is create a drop down list for the times that I need, I decided that would work better than having it use the current time for various reasons based on the information I need. I have made the formula work that will allow me to pull the data I need based on the time, but I can't figure out how to get it to do it based on the date.
I'm working with two separate tabs, the main tab has the drop down list with the time. The second tab has the information I am pulling from, its a chart that has each day of the week, with a breakdown of every hour of the day, i.e.
......Sunday..........Monday..........Tuesday
12 ...XYZ. ..............ABC ...............123
1 ......ABC .............DEF ................123
2 .....GHI ..............123 ................QRS
So, I just need to be able to select 12, for example, from my drop down menu and then have the excel file automatically put the coordinating data, for example if it were Monday, ABC, in the cell.
I think I pretty much have everything else in the file working, I have some conditional formatting going, I have the date that I can use if needed, etc. this is just what I'm stuck on. I currently have it where I can pull all the data for Sunday, it's just getting the file to know what day it is and pull based on that.
I hope this all makes sense, please let me know if I need to clarify anything.
Thank you!
