Hi ,
I do have a problem on key in a group of vendor invoices in excel to be uploaded to my accounting database where in my excel i do have a table consist of a group of vendor name with a unique code to represent the vendor.For example in excel when i key in a short form name XYZ in columm E2 it will automated come out the vendor code in columm F2 by using vlookup formula (=VLOOKUP(E2,$P:$Q,2,0)),the problem is that i wan a dialog box to appear or any kind of notification can appear in my excel to show me the full name of XYZ that is XYZ Private Ltd so it can be a cross check reference for me to see whether the vendor i entered is same with invoices. As an example of data i have in the Vlookup table is Columm O is the vendor full name, Columm P is the vendor short form name for me do linkage and Columm Q is the vendor code.
I do have a problem on key in a group of vendor invoices in excel to be uploaded to my accounting database where in my excel i do have a table consist of a group of vendor name with a unique code to represent the vendor.For example in excel when i key in a short form name XYZ in columm E2 it will automated come out the vendor code in columm F2 by using vlookup formula (=VLOOKUP(E2,$P:$Q,2,0)),the problem is that i wan a dialog box to appear or any kind of notification can appear in my excel to show me the full name of XYZ that is XYZ Private Ltd so it can be a cross check reference for me to see whether the vendor i entered is same with invoices. As an example of data i have in the Vlookup table is Columm O is the vendor full name, Columm P is the vendor short form name for me do linkage and Columm Q is the vendor code.