vba - Excel Looping through a table and deleting a specific cell -

I am trying to loop through a table in excel. From the table (A1: C50), the column is A serial number, column B is, column C is the total.

I have a cell D10 which is a random serial number. I want a loop through the table and check that the serial number in the table corresponds to my serial number in D10 and remove the correspongding income cell of that line, whether it is possible using VBA.

Thank you in advance.

  x = 1 to 50 if the cell (x, 1). Price = Room (10, 4). Then the value table (x, 2). Value = "" end if next x