Spreadsheet: 88486d1288283628-validation-locks-validation
Sheet: Example

 |  |  | SHEET 1 |  |  |  |  |  | SHEET 2
 |  |  |  |  |  |  |  |  |  |  | Is there a way to lock the Validation in Sheet 2 If I am utilizing lookup functionality off Sheet 1 without having to go through the traditional validation steps one column at a time?  All the lookups will only return results that are included in the Validation category options
 |  |  | External Appraisal- Real Estate |  |  |  |  |  | External Appraisal- Real Estate
 |  |  | Internal Appraisal- Real Estate | 0-25% |  |  |  |  | Internal Appraisal- Real Estate | 0-25%
 |  |  | Tax Assessment- Real Estate | 25-50% |  |  |  |  | Tax Assessment- Real Estate | 25-50%
 |  |  | External Evaluation- Non-real estate | 50-75% |  |  |  |  | External Evaluation- Non-real estate | 50-75%
 |  |  | Internal Evaluation- Non-real estate | 75-100% |  |  |  |  | Internal Evaluation- Non-real estate | 75-100%
 |  |  | N/A- Unsecured |  |  |  |  |  | N/A- Unsecured
 |  |  | Primary Source of Value (Primary Collateral) | Non Accrual Projection October - 2010 |  |  |  |  | Primary Source of Value (Primary Collateral) | Non Accrual Projection October - 2010
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% | 2 | 2
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 3
 |  |  | External Evaluation- Non-real estate | 0-25% |  |  |  |  | External Evaluation- Non-real estate | 0-25% |  | 4
 |  |  | Internal Evaluation- Non-real estate | 0-25% |  |  |  |  | Internal Evaluation- Non-real estate | 0-25% |  | 5
 |  |  | Internal Evaluation- Non-real estate | 0-25% |  |  |  |  | Internal Evaluation- Non-real estate | 0-25% |  | 6
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 7
 |  |  | 0 | 0-25% |  |  |  |  | 0 | 0-25% |  | 8
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 9
 |  |  | Internal Evaluation- Non-real estate | 0-25% |  |  |  |  | Internal Evaluation- Non-real estate | 0-25% |  | 10
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 11
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 12
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 13
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 14
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 15
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 16
 |  |  | Internal Evaluation- Non-real estate | 0-25% |  |  |  |  | Internal Evaluation- Non-real estate | 0-25% |  | 17
 |  |  | Internal Evaluation- Non-real estate | 0-25% |  |  |  |  | Internal Evaluation- Non-real estate | 0-25% |  | 18
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 19
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 20
 |  |  | 0 | 0-25% |  |  |  |  | 0 | 0-25% |  | 21
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 22
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 23
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 24
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 25
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 26
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 27
 |  |  | 0 | 0-25% |  |  |  |  | 0 | 0-25% |  | 28
 |  |  | Tax Assessment- Real Estate | 0-25% |  |  |  |  | Tax Assessment- Real Estate | 0-25% |  | 29
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 30
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 31
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 32
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 33
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 34
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 35
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 36
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 37
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 38
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 39
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 40
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 41
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 42
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 43
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 44
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 45
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 46
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 47
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 48
 |  |  | External Appraisal- Real Estate | 75-100% |  |  |  |  | External Appraisal- Real Estate | 75-100% |  | 49
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 50
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 51
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 52
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 53
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 54
 |  |  | External Appraisal- Real Estate | 0-25% |  |  |  |  | External Appraisal- Real Estate | 0-25% |  | 55
 |  |  | External Appraisal- Real Estate | 25-50% |  |  |  |  | External Appraisal- Real Estate | 25-50% |  | 56
 |  |  | External Appraisal- Real Estate | 25-50% |  |  |  |  | External Appraisal- Real Estate | 25-50% |  | 57
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -
 |  |  | - | -