I have data from 2 days on two tabs on the same sheet, I want to compare the two using account code column F and then return missing data from each tab (account code on 1 tab but not the other both ways) but only if account code is 6 characters long (alpha-numeric). the data returned needs to include the account code, name and e-mail. On tab 3 I've but how the data returned might look like? I've been doing this using multiple queries and a vlook up, is there a way of incorporating this into just 1 query? Thanks. Link below to sample spreadsheet.