Extract values with non-array formula

Looking for formula to extract values in column A (Distinct Zippa heading) into column D. Column B data is the primary data to be used to look into column A and if there is a match of the data in column B in column A, the formula should extract the match in column A into column D. See sample data.

Thanks