Lobsterboy1
Established Member
- Joined
- Mar 22, 2011
- Messages
- 415
- Reaction score
- 155
- Points
- 146
After see all the excel wizards help someone out the other day, I am hoping they can help me. I have inherited a excel spread sheet at work as someone has left, and I have the most all be it limited understanding of excel. Here is a mock up of it.
The first OPEN, DEL and CLOSE cells are filled in manually, then the USED is just OPEN + DEL - CLOSED. From then on the OPEN is just the CLOSED value from the day before and the DEL is filled in manually. What I am trying to do when I put a date in cell E13 cells B16 to B20 give me the OPEN value from that day. I have been trying to use index and match but I am not having much joy