Using Excel's error-checking functions

- 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.…