Hi,
I do have a a excel file where by in Columm O is the vendor full name,Columm P is short name of the vendor, & Columm Q is the vendor code so in order for me to key in my invoice entry to be uploaded in my accounting system the vendor code is very essential for me, so in the columm E is where i input on the vendor short name and i used =VLOOKUP(E2,$P:$Q,2,0) to link the short name with to automated get the vendor code so what i wanted is can there be any pop up dialog box or notification appear the full name of the vendor once the vendor code is link to the cell so it can be a cross check reference for me to view my invoices entry is match with the vendor.Because sometime i may overlook and key in the wrong vendor short name so if there is a dialog box appear on every vendor entry i entered in excel it will ease my work.
Bookmarks