Hi Guys
Having tried to avoid Excel for the last few years, I'm now having to build a somewhat (to me at least) complicated spreadsheet
to calculate my teaching hours.
I need to fetch the date when I've actually worked - the idea is to select the class form a pick list on the left hand side, input the amount of hours under the date.
On my Work-Hrs sheet I need to show first, the Date - Class - Hours... Simple really. I can find the row contenting the class but I'm unable to find the hours in the row so that can get the corresponding date.
I've tried Index and match to no avail.
screen grab.jpg
I would be soooo grateful for any ideas or tips
Gary
Bookmarks