Vlookup add a column with state names from state abbreviations

[garcshan]

Hello I'm very new to Alteryx. I have an excel file with state abbreviations as well as other data and I want to add a column next to the state abbreviations based on another file that has both the abbreviations and corresponding state names. I tried to use the join tool but it doesn't seem to work when there's other data in the file. Can anyone help me with making a vlookup type function so that I can get the state names pulled into a new column? Thank you!!

[Emil_Kos · Accepted solution]

Hi @garcshan,

Find and replace work like a vlookup. Please write find in a search window and click example to explore how it works.