EXCEL VBA VLookUP

[atame]

Im trying to write some code for a button click to perform a VlookUp.

Sheet1 = Payment Form, Sheet2 = Global, Sheet3 = Details

Button will be on Sheet "Payment Form".

This would be the code for Cells in Global Sheet,
O1 = <code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">=VLOOKUP(BA,Details!A:H,8,0)</code> P1 = <code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">=VLOOKUP(BA,Details!A:H,6,0)</code> Q1 =<code style="margin: 0px; padding: 1px 5px; border: 0px; font-size: 13px; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, sans-serif; white-space: pre-wrap; background-color: rgb(238, 238, 238);">VLOOKUP(BA,Details!A:H,5,0)</code>

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.

For Example: Global, Cell B1 = 27801. In Details match found, then do the above codes from Columns O, P & Q. Global, B2 = 27802. In Details not matching record found, row deleted. Continue to row 3 & 4 ......