I have one column having many abbreviated name which I want to change to its
full name in other column like A,AL,CS,RP,TQ,NSD,PORT,DKL and so on which is
to be changed to Auckland, Aliappa, Castariaca, Rosepet,Time
qou,Nasdon,Portariac,Docklone I tried with
=lookup(a1,{"A","AL"},{"Auckland","Aliappa"}) it replace some name but some
wrong replacing.