Excel’s VLOOKUP and HLOOKUP function, which stands for vertical and horizontal lookup, is used to search for wanted information stored in sheet which could be in same or different XLS file.
If you have sheet “order” with enlisted items and sheet “prices” with items price list you can search for the prices of ordered items to calculate total amount of order.
If you have sheet “overdue” with enlisted over debt partners for sending warning letter and you have sheet “partner master data” with full partners addresses, you can search for selected addresses using these LOOKUP function.
Sometimes master data in your ERP or similar software could be full with obsolete definitions not used anymore. It could look like they should be erased from databases to make data more reliable. There are to many reasons not to do it. Regardless it is item master data, partner master data or any other master data type… Once opened master definitions should exist for all eternity. Clearing those unused definitions could cause more troubles than benefits.
At its simplest level, ERP is a set of best practices for performing the various duties in the departments of your company, including in finance, manufacturing and the warehouse. To get the most from the software, you have to get people inside your company to adopt the work methods outlined in the software. If the people in the different departments that will use ERP don’t agree that the work methods embedded in the software are better than the ones they currently use, they will resist using the software or will want IT to change the software to match the ways they currently do things. This is where ERP projects break down.
Information technologies today put us (IT persons) in more advantage position compared to other peoples. Doing this job for several years I often come into position when I questioning myself – Am I still on a good way or I’m endangered to mislead myself? 
Almost a year ago, when I’ve talked to manager&owner of one domestic business software company, I’ve been asking him why talking codes are not well supported in their products. His answer was no one is using them anymore, they are obsolete. After one more year of experience in ERP area my conclusion is that you can found talking codes very attractive solutions. If they are implemented on a good way they will save thousands working hours to related analyst position within your company.
On the first day, I’ve crated Radenkovich’s Blog. A finest place on Web where you can found much great business and IT related stuff. Or not? Anyhow you will not found out if you stop reading here…