I've actually noticed an issue with what I'm needing to do. This seems to be a very good push in the right direction, but I think unless I set things up wrong that this formula is only comparing things in this manner: B2 with H2, B3 with H3, etc.
I have two completely different lists from different sources, so things are in different orders too. I'm basically needing to compare, for example, B2 with EVERY cell in column H in looking for a match. Would I need to set up some sort of macro to do this? Also, the search can't be case sensitive, so that "1234 Main St" and "1234 MAIN ST" are recognized as the same. Thanks again!