Need to create a new column with manual formula and reference to an external source file

[itssreeji]

Hi there,

Need your expertise for the below points. Inlcuding the sample file for your reference.

1.  Need to create a new column with manual formula like concatenation and IF

2. And to create a new column with reference to an external file wiht the help of vlookup

[DavidSkaife]

Hi @itssreeji 

Here's my approach:

Create a Lookup table to map the location codes to the name of the location, and use the find/replace tool to apend the field on based on matching Location codes (i'd do it as a lookup table rather than a formula as that way you don't need to amend the formula when a new location is needed, you just add the location and the name to the Lookup table instead)

Concatenating the two fields together is then done in the formula tool.

I've attached the workflow for you to see.

RE: part three of your questions -  if i'm understanding it correctly you should be able to create the new column using the find/replace tool if you want to have a go at it!

[binuacs]

@itssreeji similar approach of @DavidSkaife , this can be done by using the Find and Replace tool