Formula Need for Main file and cross reference file

[ronrona96]

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 solution]

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!

[ronrona96]

Thank you for your quick reply! I am unable to check the boxes in the join which is odd, but I can get it to join, so thank you. I will use the select tool to deselect the column that I will not keep. I really appreciate your quick reply. Thank you again!