Two way lookup to identify missing data query - google sheets

by Alan Allen   Last Updated January 11, 2018 20:03 PM

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.

link to sample sheet



Related Questions



How to nest table array into VLOOKUP function?

Updated December 06, 2017 12:03 PM