Hello all,
I am new to this site and excel and hope you can help me in what I'm trying to achieve.
Basically, I have two worksheets.
Worksheet #1 contains a CEP and UF_ column. CEP is the zip code for Brazil cities and UF_ is the state abbreviation.
Worksheet #2 contains a CEP and UF_ column as well.
Worksheet #1 contains the correct CEP matched with the correct UF_.
What must I do to have the CEP in Worksheet #2 search and match the CEP in Worksheet #1, and if there is a match, the UF_ field in Worksheet #2 will be updated with the value of the UF_ field in Worksheet #1?
Example file attached.
Thanks in advance.
Bookmarks