Data Validation

[gavindavey]

Hi

I am trying to do a data validation list where only the on the form below where if I mark a one in any of the columns in blue I only get these result from my data validation list rather than them all.

So if I have a 1 in Type Specific and Land Reg columns then on the same row under Errors I would only be able to select form these two list. My data validation list is below.

[TABLE="width: 1308"]
<tbody>[TR]
[TD]Fundamental
[/TD]
[TD]Building Details
[/TD]
[TD]Type Specific
[/TD]
[TD]Listing Details
[/TD]
[TD]Image
[/TD]
[TD]Deals
[/TD]
[TD]Contacts
[/TD]
[TD]Land Reg / RoS
[/TD]
[TD]Rates
[/TD]
[TD]Error 1
[/TD]
[TD]Error 2
[/TD]
[TD]Error 3
[/TD]
[TD]Error 4
[/TD]
[TD]Error 5
[/TD]
[TD]Error 6
[/TD]
[TD]Error 7
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 406"]
<tbody>[TR]
[TD]Overview - Missing / Incorrect - NIA
[/TD]
[/TR]
[TR]
[TD]Overview - Missing / Incorrect - TFS
[/TD]
[/TR]
[TR]
[TD]Overview - Missing / Incorrect - RBA Breakup
[/TD]
[/TR]
[TR]
[TD]Overview - Missing / Incorrect - YOC
[/TD]
[/TR]
[TR]
[TD]Overview - Missing / Incorrect - Construction Type
[/TD]
[/TR]
[TR]
[TD]Overview - Missing / Incorrect - Secondary Type
[/TD]
[/TR]
[TR]
[TD]Overview - Missing / Incorrect - Car Parking
[/TD]
[/TR]
[TR]
[TD]Overview - Missing / Incorrect - Site Size
[/TD]
[/TR]
[TR]
[TD]Overview - Missing / Incorrect - Sprinkler type
[/TD]
[/TR]
[TR]
[TD]Overview - Missing / Incorrect - Footprint
[/TD]
[/TR]
[TR]
[TD]Building Note - Missing
[/TD]
[/TR]
[TR]
[TD]Building Note - Spelling or Grammar
[/TD]
[/TR]
[TR]
[TD]Type Specific - Missing / Incorrect Loading docks
[/TD]
[/TR]
[TR]
[TD]Type Specific - Missing / Incorrect Clear Height
[/TD]
[/TR]
[TR]
[TD]Type Specific - Missing / Incorrect Owner Occupied/Tenancy
[/TD]
[/TR]
[TR]
[TD]Type Specific - Missing / Incorrect LEED Certification
[/TD]
[/TR]
[TR]
[TD]Type Specific - Missing / Incorrect BREEAM
[/TD]
[/TR]
[TR]
[TD]Type Specific - Missing / Incorrect Elevators
[/TD]
[/TR]
[TR]
[TD]Type Specific - Missing / Incorrect Features
[/TD]
[/TR]
[TR]
[TD]Type Specific - Missing / Incorrect Frontage
[/TD]
[/TR]
[TR]
[TD]Type Specific - Missing / Incorrect Floor
[/TD]
[/TR]
[TR]
[TD]Type Specific - Missing / Incorrect Columns
[/TD]
[/TR]
[TR]
[TD]Type Specific - Missing / Incorrect Truck Wells
[/TD]
[/TR]
[TR]
[TD]Type Specific - Missing / Incorrect Utilities
[/TD]
[/TR]
[TR]
[TD]Type Specific - Missing / Incorrect Rail Line
[/TD]
[/TR]
[TR]
[TD]Type Specific - Missing / Incorrect Crane Service
[/TD]
[/TR]
[TR]
[TD]Type Specific - Missing / Incorrect Power
[/TD]
[/TR]
[TR]
[TD]Listing Details - Missing / Incorrect s - Missing / Incorrect Space Use
[/TD]
[/TR]
[TR]
[TD]Listing Details - Missing / Incorrect - Missing / Incorrect Size
[/TD]
[/TR]
[TR]
[TD]Listing Details - Missing / Incorrect Marketing Address
[/TD]
[/TR]
[TR]
[TD]Listing Details - Missing / Incorrect Rent
[/TD]
[/TR]
[TR]
[TD]Listing Details - Missing / Incorrect Service
[/TD]
[/TR]
[TR]
[TD]Listing Details - Missing / Incorrect Service Charge
[/TD]
[/TR]
[TR]
[TD]Listing Details - Missing / Incorrect Condition
[/TD]
[/TR]
[TR]
[TD]Listing Details - Missing / Incorrect Build Out
[/TD]
[/TR]
[TR]
[TD]Listing Details - Missing / Incorrect Space Breakdown
[/TD]
[/TR]
[TR]
[TD]Listing Details - Missing / Incorrect Vacancy Date
[/TD]
[/TR]
[TR]
[TD]Listing Details - Missing / Incorrect Vacating Tenant
[/TD]
[/TR]
[TR]
[TD]Listing Details - Missing / Incorrect Term
[/TD]
[/TR]
[TR]
[TD]Listing Details - Missing / Incorrect Rent Reviews
[/TD]
[/TR]
[TR]
[TD]Listing Details - Missing / Incorrect Loading Docks
[/TD]
[/TR]
[TR]
[TD]Listing Details - Missing / Incorrect Listing Agents Details
[/TD]
[/TR]
[TR]
[TD]Listing Details - Missing / Incorrect Images
[/TD]
[/TR]
[TR]
[TD]Listing Details - Missing / Incorrect Goad
[/TD]
[/TR]
[TR]
[TD]Listing Details - Missing / Incorrect PDF
[/TD]
[/TR]
[TR]
[TD]Listing Details - Missing / Incorrect Under Offer
[/TD]
[/TR]
[TR]
[TD]Space Note - Spelling or Grammar
[/TD]
[/TR]
[TR]
[TD]Listing Details - Missing / Incorrect Features
[/TD]
[/TR]
[TR]
[TD]Listing Details - Missing / Incorrect
[/TD]
[/TR]
[TR]
[TD]Deals - Missing Info
[/TD]
[/TR]
[TR]
[TD]Deals - Missing
[/TD]
[/TR]
[TR]
[TD]Deals - Incorrect Info
[/TD]
[/TR]
[TR]
[TD]Land Reg Date
[/TD]
[/TR]
[TR]
[TD]Land Reg - Missing Owner
[/TD]
[/TR]
[TR]
[TD]Land Reg - Incorrect Owner
[/TD]
[/TR]
[TR]
[TD]Image - Missing
[/TD]
[/TR]
[TR]
[TD]Image - Incorrect
[/TD]
[/TR]
</tbody>[/TABLE]

 

[sergioMabres]

Hi gravin
Look for Conditional Drop Down Lists in Excel in a search engine. There is a couple of ways to do what you need
Cheers
Sergio