title: When typing a item code into one cell, how to get a description and price to automatically go into other cells
body: <p>This is probably a really easy fix but I'm having trouble getting it to work.  I am a frequent user of functions in excel but haven't dabbled with VBA much.  </p>
  
  <p>I have a vendor that refuses to itemize their invoices.  It becomes very difficult for me when making a PO.  I have begun to itemize their invoices myself but as they get bigger and bigger this is consuming more of my time.  I would like to be able to type an item code into a cell and in the two cells to the right automatically populate the description and the price. </p>
  
  <p>For example:<br>
  Type "Temporary Wire" in A2, and "Installing a Temporary Wire Gap Gate up to 100 foot wide" would automatically populate in B2, followed by "$650.00" automatically populating in C2.</p>