title: How to do the equivalent of a vlookup in Powershell
body: <p>Hope you all can give me a hand with this powershell question.</p>
  <p>So what I need is to do a get-childitem on a directory and collect a lot of information from the properties from this cmdlet and store it into something like a hastable. But for one property of the resulting hastable, I need that data to be filled in by grabbing the value of a property from an import-csv generated object--matched on a value from my first object.</p>
  <p>So like</p>
  <pre><code>PSObject A (from GCI)
  $name = a.fullname
  $extension = a.extension
  $height = (go look in object b and find the height value for where a property (lets say fullname) of object a matches)
  
  PSObject B (from import-csv)
  B.height
  B.fullname (this is what I want to match on object a)
  
  </code></pre>
  <p>I know this probably isn't the best formatted question but it's the best I can do without having to explain other weird parts of my code.</p>
  <p>Thank you</p>