Formula Need for Main file and cross reference file

Question

Good Evening - I am in need of assistance with a formula.

Scenario:

I have a Main file with Name, Level, Hours and Market. Some of the Markets in the main file are labelled incorrectly.

I have a cross reference file that has Name and Market only. The Markets are all correct in cross reference file.

Can someone please assist me with a formula that reads: if the Name in the cross reference file, matches the name in the Main file, then take the market aligned to that name from the cross reference file and change it in the Main file.

I have to use the Main file for my dataset. Names appear multiple times and it has over 600k rows of data that I need. Any help is greatly appreciated!

echuong1 · Accepted Answer

This can be achieved with a Join tool, rather than a formula. Your join will act as a vlookup.

In the join, you'll join by the Name fields. Within the Join, you can configure it to take the Market value from the reference table, and exclude the Market value from the original dataset that may be inaccurate. Hope this helps!