Noobie Question: Value based on mulit criteria

[fodzilla]

Hi All,

Need a little help with a formula or put easliy as a marco I can embed in my VBA code.

I require the score on sheet2 placing in the score col on sheet 1.

The issue is that the score on the row on sheet2 needs to appear against each and every record on sheet 1 that meets set criteria.

The criteria is:
The agent name must match
The date must match
The activation date on sheet 2 must be between the starttime and endtime on sheet1.

Again the record on sheet2 need to populate multiple records on sheet1 when required and that not all sheet1 records will require a score if the criteria doesn't match.

Hope this make sense. I have attached a pic to help if needed.

Thanks in advance
Fodzilla

 

[fodzilla]

Just to confirm I have already tried to us a Vlookup and =Sumif. I do have 2007 and know a little about =sumifs but don't think this is the correct use of them as I'm looking at a range of values that could be returned.

Thaks
Fotis

 

[fodzilla]

Hi Everyone,

Can anyone help with this? Been trying it for hours and still not got anywhere. Sorry but I think it may be beyond me here.

 

[danzon]

How about this idea... tough to explain so I used a screen pic

You will need to anchor ($) some of those cell references as appropriate