| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
msgbox / inputbox etc
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inputbox with VBA | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| MsgBox compile error in Excell | Excel Discussion (Misc queries) | |||
| MsgBox with condition and showing details | Excel Worksheet Functions | |||
| Msgbox | Excel Worksheet Functions | |||
Hybrid Mode
