I need to select points based on a field in the attribute table that includes their address. I have a list of addresses in an excel document that I want to select from this field. Is there any way this can be done using python? Would greatly appreciate any help as this would save me a lot of time.
Join the tables based on the address field then select by attribute where the joined address field is not null. If the address fields do not match exactly you could use string formatting to adjust your excel addresses before joining.