Lookup Function

**lstevenson** · 07-08-2013, 09:54 PM

HI

I am trying to put together a report where there are two rows with start date and end date, then a row witht the staff name. What I want to be able to do is enter in a date range then a staff name and have a formula that looks up the date range and name in another sheet and return the number of hours they have completed training for the dates entered.
I have used lookups before but still new with them and just a little unsure how to get it to look at the date range then the name then add up the hours spent training.

Help would be much appreciated!

**Tony Valko** · 07-08-2013, 10:01 PM

I think we're going to need to see a sample file to figure this out. Make sure you tell us what result you expect.

**lstevenson** · 07-08-2013, 10:10 PM

Here is a basic sample. first sheet is the report, underneath the dates and name would be the reporting, so it would return hours trained and type of training