Hi,
I want to create a macro or a formula which will
create the following formula.
if first 2 letters in column 'H' items codes contains
BT then it will show BTS and likewise if
MW then Minilink / Access Link
BS then BSC
MS then MSC
IN then IN
TE then Transmission
TS then Transmission
NM then OSS
SE then Services
AN then GSM antenna
NL then NLD-OFC
MP then MPBN
VA then VAS
TW then Civil & Infra
ST then Civil & Infra
DG then Civil & Infra
TF then Civil & Infra
IF then Civil & Infra
PP then Civil & Infra
BA then Civil & Infra
AC then Civil & Infra
IN then Civil & Infra
SH then Civil & Infra
PS then Civil & Infra
OF then NLD-OFC
NW then VAS
gp then VAS
UP then Civil & Infra
BS then BSC
BA then Civil & Infra
AC then Civil & Infra
and lastly if column I has a "service" word in it it will show "services" as well
Bookmarks