Saturday, December 14, 2013

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   Dec-14, 2013
question by Johnson Controls (!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