yogi_Compute Row By Row The Latest Specified Entry In A Row And The Corresponding Date in The date Row

                                          Google Spreadsheet   Post  #1094
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 3, 2013
user JFC1111 :(http://productforums.google.com/forum/?zx=saj65vfnlqxo#!mydiscussions/docs/Rt7EzAjLJIQ)
I have a row that represents every day of any given month counting billable days. I also track billing status changes with a 3 digit code. I would like to have the row searched and if a code is found then it is translated into a word, like "community" into its own column. I would also like to return the date the code was entered into another column.
---
Here is the link to the sheet.

Thanks

https://docs.google.com/spreadsheet/ccc?key=0ApSW4YxneN_BdFNHRTVyVE9ZR0pHall2aERDX3lqMHc&usp=sharing

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

following is a solution to the problem