Find Replace/Join based on Min and Max Zip code

Lucasvital

Hi,

I have the zip code field in my excel file A that I want match (either find and replace, or join) to a specific field in excel file B based on zip code; however, zip codes in file B are based on a range of Min and Max (split in two columns). Any tips on easiest way to solve? I've been trying to create some if formulas based on zip code values but might exist an easier solution than that.

Thanks

MichalM

@Lucasvital 

I'm assuming here so please correct me if I'm wrong - if we increment by 1 from Min (0) to Max (100) - we'll get all the Florida Zip codes, correct? If that's the case, we can use the Generate Rows tool to achieve this.

The result will be a set of numbers from 0 to 100 which then need to be padded on left with 0 to complete the full Zip - we achieve that using the formula tool.

PadLeft(ToString([Zip]), 5, "0")

Once ready, we can use the Join tool to append the Field Name based on a matching Zip.

Example attached.

min-max-zip.yxmd