title: Convert Excel Formula to VBA
body: <p>I have this formula that looks at various criteria across multiple columns and checks to see that if all the all the criteria match, it will paste data from one column to another.  I've tried a couple ways to get it into VBA, but I can't seem to get anything to work.  Thanks!</p>
  
  <pre><code>=INDEX($D$2:$D$1112,MATCH(1,($A$2:$A$1112=$U$7)*($C$2:$C$1112=$W$7)*($B$2:$B$1112=F3),0))
  </code></pre>