title: look up data left and right (with or without VBA)
body: <p>I have an excel file with 2 worksheets.</p>
  
  <p>On the first worksheet called "data", I want to look up data from the second worksheet called "List". The data that I need to look up comes from the left and right of the look up value. Therefore, I would like to know your suggestion on the best formula or code to be collect data from the both side simulaniously. </p>
  
  <pre><code>Worksheet 1 name "Data" &gt; Value to look up is in "B7" is "John"
  
  Worksheet 2 name "List" &gt; Matching value to be looked up is in "D7" is "John"
                      &gt; Return a value from "A7" -3 cells to the left
                      &gt; Return a value from "G7" 3 cells to the right
  </code></pre>
  
  <p>Any suggestions? </p>