Excel Match Up with returning value

Excel Match Up with returning value

I'm doing a survivor pool and i'm trying to create a spreadsheet that will
do the following: SHEET 1 = Total Stats SHEET 2= INPUT DATA
SHEET 2, every week I will input name of the survivor knocked out. Sheet
1, I need it to return my point system.
Anyways, just thought I would give a brief explanation before I try to
explain the formula I need.
SHEET 1, row A4 = Aras. Now if I enter Aras in sheet 2 row B3 as being
kicked off I need C4 on sheet 1 to return 0. Which, I've used this formula
=IF(A4<>'Weekly Input Data'!B3,1,0) and it works BUT my dilema - for week
2 I need this to remain 0 but it needs to look in another cell for week 2
on sheet 2, so if John gets kicked off in week 2 it needs to show 0 for
both Aras and John and for all the other survivors it needs to show value
of 1 since that survivor made it through the week. I think I need to
insert an array of cells to look up on sheet 2 but this is where i'm lost?
PLEASE HELP ME!! let me know if you have any questions b/c I had a hard
time explaining it.
THanks!