This is also posted in public.excel.misc


"samenvoegen van sheets"

wrote in message
...
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...