i need a macro code to identify the words which are mentioned inside the
bracket.
The macro should create a variable for the words inside the bracket then
compare the variable which are in bracket and pull out the items related to
that particular.

example:

Question:
sheet one contain the below details
(TNT)Titan co
(ANPS)Assocation
(SSTS)Socity

Sheet two contain the below details
coln1. coln2.
(TNT) TT
(ANPS) AA
(SSTS) SS


Answer: my macro should do a kind of vlookup b/w sheetone and sheettwo and
it should through the answer as shown below


TT
AA
SS

You can use a "Helper" column on sheet one. Enter the formula

=LEFT(A1,FIND(")",A1))

and drag down the column. Use the helper column in your VLookup.

Regards,
Charlie

"Ranjit kurian" wrote:

> i need a macro code to identify the words which are mentioned inside the
> bracket.
> The macro should create a variable for the words inside the bracket then
> compare the variable which are in bracket and pull out the items related to
> that particular.
>
> example:
>
> Question:
> sheet one contain the below details
> (TNT)Titan co
> (ANPS)Assocation
> (SSTS)Socity
>
> Sheet two contain the below details
> coln1. coln2.
> (TNT) TT
> (ANPS) AA
> (SSTS) SS
>
>
> Answer: my macro should do a kind of vlookup b/w sheetone and sheettwo and
> it should through the answer as shown below
>
>
> TT
> AA
> SS

hi Charlie

Thanks for the code it really helped me.

is there any way to remove the brackets example:

Question : (TNT)
Answer : TNT (remove the bracket, then give only the text)


"Charlie" wrote:

> You can use a "Helper" column on sheet one. Enter the formula
>
> =LEFT(A1,FIND(")",A1))
>
> and drag down the column. Use the helper column in your VLookup.
>
> Regards,
> Charlie
>
> "Ranjit kurian" wrote:
>
> > i need a macro code to identify the words which are mentioned inside the
> > bracket.
> > The macro should create a variable for the words inside the bracket then
> > compare the variable which are in bracket and pull out the items related to
> > that particular.
> >
> > example:
> >
> > Question:
> > sheet one contain the below details
> > (TNT)Titan co
> > (ANPS)Assocation
> > (SSTS)Socity
> >
> > Sheet two contain the below details
> > coln1. coln2.
> > (TNT) TT
> > (ANPS) AA
> > (SSTS) SS
> >
> >
> > Answer: my macro should do a kind of vlookup b/w sheetone and sheettwo and
> > it should through the answer as shown below
> >
> >
> > TT
> > AA
> > SS

=MID(A1,2,FIND(")",A1)-2)

"Ranjit kurian" wrote:

> hi Charlie
>
> Thanks for the code it really helped me.
>
> is there any way to remove the brackets example:
>
> Question : (TNT)
> Answer : TNT (remove the bracket, then give only the text)
>
>
> "Charlie" wrote:
>
> > You can use a "Helper" column on sheet one. Enter the formula
> >
> > =LEFT(A1,FIND(")",A1))
> >
> > and drag down the column. Use the helper column in your VLookup.
> >
> > Regards,
> > Charlie
> >
> > "Ranjit kurian" wrote:
> >
> > > i need a macro code to identify the words which are mentioned inside the
> > > bracket.
> > > The macro should create a variable for the words inside the bracket then
> > > compare the variable which are in bracket and pull out the items related to
> > > that particular.
> > >
> > > example:
> > >
> > > Question:
> > > sheet one contain the below details
> > > (TNT)Titan co
> > > (ANPS)Assocation
> > > (SSTS)Socity
> > >
> > > Sheet two contain the below details
> > > coln1. coln2.
> > > (TNT) TT
> > > (ANPS) AA
> > > (SSTS) SS
> > >
> > >
> > > Answer: my macro should do a kind of vlookup b/w sheetone and sheettwo and
> > > it should through the answer as shown below
> > >
> > >
> > > TT
> > > AA
> > > SS