Forum Discussion
How to validate completeness of 1 list against another list
Hi, Refer to screenshot below. List 2 has for each "Type" there should be the corresponding "Composite"s. Is there a way to validate or point out in List 1 which "Accounts" are missing any "Compo...
=IF(ISNA(VLOOKUP(F3&G3,$B$3:$B$12&$C$3:$C$12,1,FALSE)),"missing in list 1","")Maybe with this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
- Thanks! That would show me what's missing in list 1 but I'm looking for whats missing in list 1 at the account level. So is there a way through formula or some other means that I can show ABC2 is missing XYZ2 and ABC is missing XYZ1 and on wards assuming there are hundreds of accounts. By doing a lookup on list 2 I can see whats missing but not by each specific account.