title: How find a Range based on one criteria then a Cell within that Range based on another criteria
body: <p>I need a way to find a Range based on one criteria then a Cell within that Range based on another criteria.</p>
  
  <p>In this case I have a worksheet that you can add as many commercial real estate properties as you want and then spread there financials. You can have up to three years of financials for each property. So in cell("G2") you would be the first properties name and then in range("G3:I3") would be statement date for each statement spread and the range("G38:I38") contains the data I ultimately need to extract. Any additional property would have the same row numbers but everything would be 6 columns to the right.</p>
  
  <p>So essentially I need to find the property name and then within that range (lets say ("G2:I60")) I need to find those the data in either G38, H38, or I38 based on the statement date needed.</p>
  
  <p>Right now I have two userforms; 1 that displays all the property names and after you select that it shows the 2nd useform which displays the statement dates. </p>
  
  <p>Can anyone help with this. Let me know if there are any unknowns I need to explain as this was difficult for me to put into words.</p>
  
  <p>Example:</p>
  
  <pre><code>Property Name:  DEF St                                      
                  12/31/2013  12/31/2014  12/31/2015
  Rental Income       150         240         485
  Expenses            100         200         300
  Net Income          50          40          185
  
  Property Name:  ACME St 
                  12/31/2013  12/31/2014  12/31/2015
  Rental Income       100         120         350         
  Expenses            75          125         180         
  Net Income          66          76          266         
  </code></pre>
  
  <p>In this example, I would need the 1st user form to find the property DEF St when selected from the list box then find the net income for whichever statement data was selected from the list box in the next user form.</p>