I have to create a formula (or multiple, whatever needs to be done) to conduct a search on a monthly list that may change and not always be exact.

It involes addresses, and group names. For example:
Address: 123 Hospital St.
Group: Physician's Associates, Suite 456

I have compiled a list of groups and addresses that I want to exclude each month for a larger raw data set. Being raw data and manual data entry, the addresses may not always be exact. Some may have an extra space, or comma, etc., and some may have "St." vs "Street" etc.

I want to be able to pull a formula into the raw data set, and do a look up to my running list of addresses to exclude. I thought about using a concatenate with left and right of the address then the group, or a full concatenate, but I am not sure this will always be accurate. There is risk that there could be duplicate addresses, with different suites.. so the search has to be somewhat specific but not exact.

Does anyone have any ideas on how to approach this?

Thank you.