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!!