Searching matching vertical and horizontal criteria in multiple sheets

From the attached Workbook:

I need to lookup 2 criteria from the ‘Tracking’ sheet (a name from column B, and a location from Row 2) and search within multiple ‘Month’ sheets (I have only shown 2 but in reality there are 12) to find the name and corresponding location vertically. I then need the ‘Tracking’ sheet cell to return a ‘1’ if the found match has a ‘Result’ column value of either “Early”, “Ontime”, or “Late”, and to be left blank for all other permutations.

I have tried with VLOOKUP, HLOOKUP, INDEX, MATCH etc but cannot bet anywhere near.

I guess my complication is search criteria listed both vertically and horizontally and finding a match in sheets in different range of cell ranges.

I have manually populated the ‘Tracking’ sheet with the expected values that should be returned if a formula works.

I would prefer a solution using standard Excel functions because others will need to understand this in the future, but VB Code will be acceptable is that is the way forward.

Thanks a bunch for any help.

Thanks for the reply p24lederc.

It's a tricky one I know, but these sheets are established and so I cannot reformat them. I will work with the formula you have suggested and try to make that work - I'll play around with it.

Thanks again for the assistance - appreciated!

It would help if you can add another column to the month tracker, then you can do a sumifs function.. like this

onroute,

Thanks for the suggestion - it must have taken some time to do that, so it is appreciated!

I see what you have done, but I think for the actual spreadsheets that I am working with, the shear number of names (in the hundreds) and locations (around 50) will make this impossible to implement. I like what you have done though, and I can actually use this in another scenario that I am working with, so it has not gone to waste I can assure you!

It does look like code is the way to go, but I will have to do some serious research on it to elevate my basic skills in this area.

Thanks again.

FlameRetired,

I think you should come out of retirement!! That is absolutely tremendous - it works! I simply have to modify the ranges to adapt it to the actuals, and there is it.

BTW: I have updated my profile - I am using Office 2013.

Thanks a million - very very cleverly done

You're welcome, glad it works. Thanks for the feedback and the rep.