|OK, your last post doesn't make sense.|
If we go back to the beginning of this thread, I read it to mean this:
- You have a list data in Sheet1!A:A.
- You want to look for each piece of data in that list and compare to the data in columns R & V on Sheet2.
- If the data does not exist in those columns, then delete that row in Sheet1.
Apparently that is not what you want to do, but I don't understand your last post.
You said "if it doesn't find a match in either of those 2 columns I would like it to delete the row in Sheet 2."
If it doesn't find a match, what row do you want to delete?
In other words, if AAAA exists in Sheet1!A:A, but not in column R or V on Sheet2, what row should be deleted? All of them? I doubt it.