Vlookup with Multiple Criteria and then send email notification
Budget: $10 – $30 USD
I have 2 google sheets with live population of data from 2 different google forms.
I have 2 people counting stock and I would like to check if the data is correct.
Create a formula for me to compare 2 sheets of data to each other. First find the match in the fourth column of each sheet. Then find the match of the fifth column in each sheet. Only if both the fourth columns and both the fifth columns match, then only must the sixth column be compared. If the sixth column does not match, an ERROR message must be shown. An email must be sent to me if data does not match. The sheets are always live as they are responses to google forms
I have 2 people counting stock and I would like to check if the data is correct.
Create a formula for me to compare 2 sheets of data to each other. First find the match in the fourth column of each sheet. Then find the match of the fifth column in each sheet. Only if both the fourth columns and both the fifth columns match, then only must the sixth column be compared. If the sixth column does not match, an ERROR message must be shown. An email must be sent to me if data does not match. The sheets are always live as they are responses to google forms