Add values from another column to required column

[Anonymous]

  Hi All,

My requirement is   replace Financial Advisory to FA –DA and  FA –JV

  Financial Advisory from Function .

FA –DA and  FA –JV  from Function – Others

‘Function’   is old column ‘Function – Others’ is newly added colum

  old :

Function
Audit & Assurance
Consulting
ERS
Financial Advisory
Internal Firm Services
Tax

  Required:

Function
Audit & Assurance
Consulting
ERS
FA –JV
FA –DA
Internal Firm Services
Tax

Thanks,

Krishna

[Chanty4u]

Missing Manual - Map...using

[HirisH_V7]

Hi,

On what basis does these replace Financial Advisory to be replaced to  FA –DA and  FA –JV if it is based on the Emp id means we have to write condition for each and every emp id.

Can you provide more info if available.

-Hirish

[Anonymous]

Hi Harish,

From March Financial Advisory divided in to FA –DA and  FA –JV .

I need to remove Financial Advisory  from Function first. next add  FA –DA and  FA –JV .

Thanks,

Krishna

[HirisH_V7]

• On what basis it got divided into FA –DA and  FA –JV From March .

• Is there any particular case for DA and JV in your logic or any other column which tells the correspondence to it.

look in that way.

-Hirish

[sunny_talwar]

How can you add two different options for one value? Is there another if here?

If(Function = 'Financial Advisory',

If(FieldName = BlahBlah, 'FA-DA',

If(FieldName = BlahBlah2, 'FA-JV')), Function)