Import into fkey based value list field
I have a excel table that needs to imported into a table with fields that include city, county, state.
In the excel file the state value is TX in my table fkey value its 12. as it the case for city and county different fkey value of course. .
Is there a work around for this outside of a find replace in excel prior to import.