In the 53rd session of Chandoo.org podcast, let’s talk about data validation.
What is in this session?
In this podcast,
- What is data validation
- How Excel DV compares with database & software DV?
- Types of data validation rules
- List & custom rules explained
- Input & error messages
- Alternatives to data validation
- Enhancing data validation
- Removing data validation rules
- Homework problem for you
- Resources & show notes
Listen to this session
Podcast: Play in new window | Download
Subscribe: RSS
Click here to download the MP3 file.
Resources for this podcast
Data validation introduction & examples:
- Excel basics: How to add drop down box data validation rules?
- Either-or condition as validation rule
- Making data validations dynamic
- VLOOKUP + Data validation = magic
- Copy data validations using Paste Special, Remove them with Paste Special
Advanced validation examples:
- Advanced data validation techniques (custom rules)
- Unsorted, duplicate column as source
- Mix conditional formatting with DV for awesome results
Data validation in play – case studies:
Additional resources:
Data validation home work – your answer
Did you get the answer for homework? Please post your answers / explanations in the comments section.
One Response to “How to compare two Excel sheets using VLOOKUP? [FREE Template]”
Maybe I missed it, but this method doesn't include data from James that isn't contained in Sara's data.
I added a new sheet, and named the ranges for Sara and James.
Maybe something like:
B2: =SORT(UNIQUE(VSTACK(SaraCust, JamesCust)))
C2: =XLOOKUP(B2#,SaraCust,SaraPaid,"Missing")
D2: =XLOOKUP(B2#,JamesCust, JamesPaid,"Missing")
E2: =IF(ISERROR(C2#+D2#),"Missing",IF(C2#=D2#,"Yes","No"))
Then we can still do similar conditional formatting. But this will pull in data missing from Sara's sheet as well.