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
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
---------------------------------------------------------------------------------------------
No comments:
Post a Comment