title: Excel using a range of cells to return value corresponding to an adjacent cell
body: <p>I am using Excelsius 2008 (Excel 2007 plus a dashboard builder) to create dashboards and publish them as webpages. </p>
  
  <p>I have a range of cells <code>A1:A20</code> that number from 1 to 20. Then Next to it I have <code>B1:B20</code> that consists of texts (e.g. B1 may have 'High Level", and B2 may have "Low Level", etc.). </p>
  
  <p>I also have indicators on my dashboard. The indicator button image has a label which can be shown when you hover over it (almost like a tool tip message box). Right now the label on the indicator can display a value in the message box with any number from <code>A1:A20</code> because I have a single cell referencing it (<code>C9</code>). That cell has a vlookup as such:</p>
  
  <pre><code> =VLOOKUP(C9,$A$1:$B$20,1,TRUE)  
  </code></pre>
  
  <p>But I am trying to make it so if a 6 appears in the cell (<code>C9</code>) and when I hover over the icon I should get the text value from <code>B6</code> not <code>A6</code>.  I am merely using the <code>Column A</code> to match the number in <code>C9</code> and if they match, then the adjacent cell's (in <code>Column B</code>) text appears. </p>
  
  <p>Can this be done with look up functions or any other command that excel has? </p>
  
  <p>Thanks for the help</p>