yogi_From Names And Weeks In Sheet1 Make A CrossTab By Name And Week In yogi_Sheet3 Showing completed not completed

                                          Google Spreadsheet   Post  #1436
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-14, 2013
question by Johnson Controls (http://productforums.google.com/forum/?zx=iqfbvnd0jbz1#!category-topic/docs/spreadsheets/VvFMaUYoq6E)
IF Function for certain value then adjacent cell value

 I want to look up in sheet1 columnA for a name(mike smith) then check cell beside his name for (week1) and if it is there then mark sheet3 cell(any cell as of now) completed,  what I am trying to accomplish is that there are 52 weeks in the year and I have several people performing audits everyweek and want to keep track of auditers and which weeks they have completed (example below)

        mike smith

Column A   Column B

week1            completed

week2            completed

week3            not completed

---------------------------------------------------------------------------------------------