title: VLOOKUP with button click
body: <p>I'm trying to write some code for a button click to perform a VLOOKUP.</p>
  
  <p>Sheet1 = Payment Form, Sheet2 = Global, Sheet3 = Details</p>
  
  <p>Button will be on Sheet "Payment Form".</p>
  
  <p>This would be the code for Cells in Global Sheet,</p>
  
  <p>O1 = <code>=VLOOKUP(BA,Details!A:H,8,0)</code><br>
  P1 = <code>=VLOOKUP(BA,Details!A:H,6,0)</code><br>
  Q1 =<code>VLOOKUP(BA,Details!A:H,5,0)</code></p>
  
  <p>I need this to loop through all rows as the amount can change each month, if a match is found the perform the VlookUp, is no match is found, the delete the row from the Details Sheet.</p>
  
  <p>For Example: Global, Cell B1 = 27801. In Details match found, then do the above codes from Columns O, P &amp; Q.
  Global, B2 = 27802. In Details no matching record found, row deleted. Continue to row 3 &amp; 4 ......</p>