Good morning Honeycoders!,
I have a scenario where I have folks importing data into a table that gets written to another table. There is a column in the import table that I would like to have the contents of that column be as a lookup in another table and if it finds the value in a column pull a value in that same row but a different column in that row and then take that value and write it to the imported value.
When the row is imported the item in Branch Number column is a long string. I'd like to do a lookup against a table that has the same strings but in the column next to it has a simple value.
Replace the value that was imported with the one that was done in the lookup.
I was thinking doing a subsitute or perhaps a formula on the column?