0

I'm trying to use the following names (Nancy, Daniel, Sergio, Patty) that are listed on the right-side column (column H) finding them on Table that is on the left-side and deleting them (along its whole row).

enter image description here

Here's how the final table would look like with the deleted rows:

enter image description here

Could this be done with a simple VLOOKUP formula?

tadm123
  • 8,294
  • 7
  • 28
  • 44

2 Answers2

1

If you are okay with just hiding the rows which contains a name in the list:

  1. Format the current data as table (should be CTRL+T).
  2. Add column 'Hide' to the table.
  3. Add this formula in the 'Hide' column: COUNTIF(H2:H5, A2)
  4. Make sure the formula is correctly defined for the entire column.
  5. You should have only '1's and '0's in this column. Filter it to show only '0' and you are done.
  6. Or you can filter to show only the '1's and delete them if you wish that.
tornadoradon
  • 400
  • 1
  • 8
  • 17
Mihael Manolov
  • 70
  • 8
1

You can't delete rows using formula. For doing that you would need VBA code. But with FILTER formula you could crate new table excluding list in H:

=FILTER(A1:C7,ISNA(MATCH(A1:A7,H2:H4,0)))

Result:

enter image description here

user11222393
  • 3,245
  • 3
  • 13
  • 23
  • Thanks, how about filtering for Name2,Name4,Name6 rows in the Table, and then, I'll just manually delete them? – tadm123 Mar 12 '23 at 20:19