msgbox / inputbox etc

Hi,

I'm using a vlookup formule to translate names into codes in a really big
excel sheet.
The problem is that if there are two time the same name, the system will
take the first code to translate the name without warning me. It can happens
that the system choose then for the wrong code.

Therefore, i would like to use a msgbox or inputbox to warn me that there
are two or more same names and to let me choose directly between the
different codes.

Is it possible ?? en if yes how can i do that?


thanks a lot for any help...

Are you using formulas for your =vlookup()?

If yes, maybe you could add a check to your formula:

=vlookup(a1,sheet2!a:b,2,false)
would become:
=if(countif(sheet2!a:a,a1)>1,"Duplicates",vlookup(a1,sheet2!a:b,2,false))

or even:

=if(countif(sheet2!a:a,a1)<>1,"Duplicates or missing",
vlookup(a1,sheet2!a:b,2,false))
(one cell)


samenvoegen van sheets wrote:
>
> Hi,
>
> I'm using a vlookup formule to translate names into codes in a really big
> excel sheet.
> The problem is that if there are two time the same name, the system will
> take the first code to translate the name without warning me. It can happens
> that the system choose then for the wrong code.
>
> Therefore, i would like to use a msgbox or inputbox to warn me that there
> are two or more same names and to let me choose directly between the
> different codes.
>
> Is it possible ?? en if yes how can i do that?
>
> thanks a lot for any help...

--

Dave Peterson

thks a lot for you proposition

have a nice day

"Dave Peterson" wrote:

> Are you using formulas for your =vlookup()?
>
> If yes, maybe you could add a check to your formula:
>
> =vlookup(a1,sheet2!a:b,2,false)
> would become:
> =if(countif(sheet2!a:a,a1)>1,"Duplicates",vlookup(a1,sheet2!a:b,2,false))
>
> or even:
>
> =if(countif(sheet2!a:a,a1)<>1,"Duplicates or missing",
> vlookup(a1,sheet2!a:b,2,false))
> (one cell)
>
>
> samenvoegen van sheets wrote:
> >
> > Hi,
> >
> > I'm using a vlookup formule to translate names into codes in a really big
> > excel sheet.
> > The problem is that if there are two time the same name, the system will
> > take the first code to translate the name without warning me. It can happens
> > that the system choose then for the wrong code.
> >
> > Therefore, i would like to use a msgbox or inputbox to warn me that there
> > are two or more same names and to let me choose directly between the
> > different codes.
> >
> > Is it possible ?? en if yes how can i do that?
> >
> > thanks a lot for any help...
>
> --
>
> Dave Peterson
>