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... |
msgbox / inputbox etc
You have one response to your post in .misc
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 |
All times are GMT +1. The time now is 02:24 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com