title: Using VLookup to find corresponding row
body: <p>I have 5 sheets in an excel file named</p>
  
  <ul>
  <li>roll 1to2.5</li>
  <li>roll2.5to5</li>
  <li>roll5to7</li>
  <li>roll 7to9.5</li>
  <li>roll 9.5to12</li>
  </ul>
  
  <p>Each sheet has two columns with the following data:</p>
  
  <pre><code>A  B
  1  22
  2  25
  3  29
  4  20
  5  18
  6  26
  7  19
  8  16
  9  21
  10 20
  </code></pre>
  
  <p>Now I have been able to do the following: In column C, if I enter a number from Col A, say "7", i get the corresponding value from Col B i.e. "19". I used the following formula</p>
  
  <pre><code>=VLOOKUP(C5,A1:B10,2,FALSE)
  </code></pre>
  
  <p>This works good uptill here.</p>
  
  <p><strong>Issue 1:</strong> Let's say I want to enter the roll in a cell say "5.5", it should automatically consider data from sheet 3 (roll5to7)</p>
  
  <p><strong>Issue 2:</strong> and then if I enter a value of ColB, say "20", it should pick up the corresponding value from ColA i.e. "4" (first match) in sheet 3.</p>
  
  <p>How can I achieve this?</p>