title: INDEX to pull multiple criteria
body: <p>I am putting together a directory of information for Hotels. My goal is to pull information from different worksheets. I normally would just do a vlookup but there is obviously multiple hotels in one city. </p>
  
  <p>I need it to pull data for all options. EX( if Phoenix, AZ is listed 3 times I need to pull it from the data to show three options). Once I have the multiple cities listed I then need to pull address, phone, hotel name, and the rate for each one.</p>
  
  <p><strong>data</strong>: </p>
  
  <p><a href="https://i.stack.imgur.com/ZTHKg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZTHKg.png" alt=""></a></p>
  
  <p>right now, I have been messing around with this formula</p>
  
  <p><code>{=INDEX(range, MATCH(lookup_value_1&amp;lookup_value_2&amp;..., lookup_range_1&amp;lookup_range_2&amp;..., match_type))}</code></p>
  
  <p>it is not doing what I want it do when I am adjusting with my criteria.</p>
  
  <p>I am kind of lost on this, I have never worked with an index formula to this degree and pulling the information from different worksheets. </p>