title: Lookup on another sheet in Excel?
body: <p>I have a very simple Excel book that I am trying to spiffy up. Here's what it looks like:</p>
  
  <pre><code>Sheet 1:
  ID    Name
  1     Bob
  2     Joe
  3     Earl
  
  Sheet 2:
  Name  ID  Whatever
  </code></pre>
  
  <p>I would like when I type a name on sheet two for it to match it to a name in sheet 1 and fill in the id for that row in the field in sheet 2. So If I type "Joe" in sheet two it will fill in 2 in the id column. </p>
  
  <p>My problem is slightly more complex than this, but I believe this is the crux of it for now.</p>