Building Name

Building Address

Owner Name

Existing Measure A

 - Potential Measure A

Existing Measure B

 - Potential Measure B

I'm then going to submit this data into a database. Here's where it gets tricky:

A)  I want to be able to pull this information back out of the database into the exact same form (so I can pull up any given site and see the full details again and be able to modify it (possible?)).

B) I want to build a Summary Report that will pull up a building's information. However, I only want Existing Measures that ALSO have Potential Measures to show up on this report. Sometimes an Existing Measure will already be energy efficient and will not have a Potential Measure associated with it. In this case it will be labeled N/A.

The hard part about this is pulling that information back out, as sometimes A will have a potential measure, and sometimes only B will have a potential measure and so on. Maybe A-D have no potentials and E-H do. So I will need ZOHO to filter out this information based on (i'm assuming) what that cell's value is (If Existing Measure A has a Potential Measure A that equals "N/A", then skip Existing and Proposed A and move on to B). Is this possible?

In Excel terms it's a simple filter... I'm just very new to ZOHO and have a requirement for this to be online and not in Excel. Please assist me! If more information would be helpful to understand what I mean please feel free to ask...

Please help!