Validating Text Data with VLOOKUP

Hi all, need help figuring out if there’s a solution to this. My coworker has a large data set and needs to verify/validate the data in Column A to Column F. Column A contains only the name of the project and column F contains a one-word label (there’s only two labels) that the project falls under. For example, Bumblebee project is labeled as “Ongoing” vs “Completed”. Issue is there is some mismatch and some projects should go under the other label, vice versa. I understand we need to have a clear distinction of what should be one label vs the other, but is there a way to validate this data without going line by line?