H & V Lookup multiple criteria

Please could someone help with a formula I require.

Example:

First range from A1 to C3

Person - 30/12/2011 - 06/01/2012
22999 - TRUE - FALSE
33388 - FALSE - TRUE

Second range from A1 to C3

Person - 30/12/2011 - 06/01/2012
22999 - 100 - 200
33388 - 200 - 100

So I want to say if person "22999" is "TRUE" for W/E 30/12/2011. Return Zero. BUT If person was FALSE for W/E 30/12/2011 return corresponding value from second range.

Let me know if you need further info

Thanks!!

Thanks for your reply Special-K

Theres three sheets. Ill attach an example

Should point out that the formula in cell E11 of above attachment should also consider the name and not just the month.

Also I'm not sure if it makes a difference ideally I would want the formula to reference Cell A11 and not B11

Any help appreciated. Thanks.

Beautifully Genius!!! Thanks a lot dilipandey!!!!

Should point out that the formula in cell E11 of above attachment should also consider the name and not just the month.

Also I'm not sure if it makes a difference ideally I would want the formula to reference Cell A11 and not B11

Any help appreciated. Thanks.

Could you work it from SRN column A. I have duplicate names in source?

Thought it was me - but it works when i moved all references to that cell

Thanks again.

Hi DILIpandey. Thanks again. As discussed Ive added the example. Many thanks