Join Dennis Taylor for an in-depth discussion in this video Using Excel's error-checking functions, part of Excel Tips Weekly.
- On this worksheet we're seeing a list of some…Excel error-checking functions, ISERR, ISERROR,…IFERROR, the AGGREGATE function by the way…does a lot of other things as well.…I'm going to be testing this with…the information we see over in Column C here.…Make that a bit wider, be using formulas.…Imagine you've got a list of social security numbers…somewhere and another list somewhere else.…In this case they're right next to each other,…but it could be from different worksheets.…We want to see if this number exists…in the list over in Column A.…
So one approach is to use the Match function.…Match function says I've got some data somewhere,…in this case it's C2, comma, we're looking in Column A…to see if it's there, comma, and we're not looking…for numbers that are close but high…or close but low, it's got to be an exact match.…As you would imagine, this would be…most of the time with social security numbers.…And as I press Enter, it did find the information,…it's in Row 7, you can see it over there.…Works just fine.…
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
Excel Tips - New This Week
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.