Spreadsheet: 197562d1354445895-formula-value-lookup-but-return-value-from-x-columns-left-and-y-rows-down-armitage2k-offset-sample-rev1-
Sheet: Summary

 |  |  |  |  | Item | Oct11 | Nov11 | Dec11 | Jan12 | [NAME] | Mar12 | Apr12 | May12 | Jun12 | Jul12 | Aug12 | Sep12
 |  |  |  |  | Are you an Ambassador Member?
 |  |  |  |  | Yes |  |  |  |  |  |  |  |  |  |  |  |  | OK
 |  |  |  |  | No |  |  |  |  |  |  |  |  |  |  |  |  | OK
 |  |  |  |  | Were you asked to join the Ambassador Programme?
 |  |  |  |  | Yes |  |  |  |  |  |  |  |  |  |  |  |  | Not OK, pulls the data from the first "Yes" it finds.
 |  |  |  |  | No |  |  |  |  |  |  |  |  |  |  |  |  | Not OK, pulls the data from the first "No" it finds.
 |  |  |  |  | Not sure/Do Not Remember |  |  |  |  |  |  |  |  |  |  |  |  | OK
 |  |  |  |  | How would you rate your overall satisfaction with the Ambassador benefits at this hotel?
 |  |  |  |  | Completely Satisfied
 |  |  |  |  | Very Satisfied
 |  |  |  |  | Satisfied
 |  |  |  |  | Somewhat Satisfied
 |  |  |  |  | Not At All Satisfied
 |  |  |  |  | Not Sure
 |  |  |  |  | Were you greeted as an Ambassador member at check-in?
 |  |  |  |  | Yes
 |  |  |  |  | No
 |  |  |  |  | Did you receive a room upgrade?
 |  |  |  |  | Yes
 |  |  |  |  | No |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] only returns value tha tis on the exact same column as the formula.
 |  |  |  |  | Not Sure
 |  |  |  |  | Did you receive complimentary fruit and mineral water?
 |  |  |  |  | Yes
 |  |  |  |  | No
 |  |  |  |  | Did you receive a personalized welcome letter?
 |  |  |  |  | Yes
 |  |  |  |  | No
 |  |  |  |  | Not Sure
 |  |  |  |  | Did you receive a complimentary daily newspaper at your room?
 |  |  |  |  | Yes
 |  |  |  |  | No
 |  |  |  |  | Not Sure
 |  |  |  |  | Opt-in to answer a few additional questions about Ambassador membership?
 |  |  |  |  | Yes
 |  |  |  |  | No
 |  |  |  |  | Overall Satisfaction with the Ambassador Programme?
 |  |  |  |  | Completely Satisfied
 |  |  |  |  | Very Satisfied
 |  |  |  |  | Satisfied
 |  |  |  |  | Somewhat Satisfied
 |  |  |  |  | Not At All Satisfied
 |  |  |  |  | Not Sure
 |  |  |  |  | Likelihood to Recommend the Ambassador Programme
 |  |  |  |  | Definitely Would
 |  |  |  |  | Probably Would
 |  |  |  |  | Might or Might Not
 |  |  |  |  | Probably Would Not
 |  |  |  |  | Definitely Would Not
 |  |  |  |  | Not Sure
 |  |  |  |  | Likelihood to Renew the Ambassador Programme
 |  |  |  |  | Definitely Would
 |  |  |  |  | Probably Would
 |  |  |  |  | Might or Might Not
 |  |  |  |  | Probably Would Not
 |  |  |  |  | Definitely Would Not
 |  |  |  |  | Not Sure
 |  |  |  |  | Value for the money
 |  |  |  |  | Much more than you paid
 |  |  |  |  | Somewhat more than you paid
 |  |  |  |  | About what you paid
 |  |  |  |  | Somewhat less than you paid
 |  |  |  |  | Much less than you paid
 |  |  |  |  | Not Sure
 |  |  |  |  | Member of PCR?
 |  |  |  |  | Yes
 |  |  |  |  | No
 |  |  |  |  | Not Sure
 |  |  |  |  | Asked to join PCR?
 |  |  |  |  | Yes
 |  |  |  |  | No
 |  |  |  |  | Not sure/Do Not Remember
 |  |  |  |  | Greeted as PCR member at check-in?
 |  |  |  |  | Yes
 |  |  |  |  | No
 |  |  |  |  | Are you a PCR Gold or Platinum member?
 |  |  |  |  | Yes - Platinum
 |  |  |  |  | Yes - Gold
 |  |  |  |  | No
 |  |  |  |  | Not Sure
 |  |  |  |  | Acknowledged as a statused member by front desk team member
 |  |  |  |  | Yes
 |  |  |  |  | No
 |  |  |  |  | Not Sure
 |  |  |  |  | Had the hotel prepared for your arrival with a pre-assigned room and registration form?
 |  |  |  |  | Yes
 |  |  |  |  | No
 |  |  |  |  | Not Sure