Grabbing data w/ multiple criteria across multiple sheets

Hi guys,

It has been a while for me on here so please bare with me. I've attached a sample sheet to this message.

What I'm trying to do is grab data from the raw data sheet and paste it into the master sheet based off of certain criteria. I want to list any accounts that are not correct.

For example, I want to look through the Raw Data sheet, find the account that contains campaigns which are not correct, and then list the name of the account on the Master sheet. I only need the account name listed once on the Master sheet.

Thanks in advance for any help!!

Hi Oeldere,

Thanks for your response!

I was actually looking for a formula, for the actual set of data I'm using spans across thousands of rows. I need it to automatically list the names of these accounts (w/ error) based off of the criteria as the raw data gets constantly updated.

See if this makes sense:

Let's say I have one "Raw Data" sheet with tons of lines; and I also have a sheet labeled "Jim" and another sheet labeled "Bob". These sheets have other data associated with them, but I'd like to have a column/table that pulls all of the accounts with errors (assigned to Jim/Bob) and list the names of these accounts under the corresponding sheet.