Excel – Using VLOOKUP to compare two lists

SharynAvatarBlog120x120
Years ago the Training and Development manager of a large organisation invited me to spend some time in their Accounts department in order to observe how the Accounts team dealt with their day-to-day tasks. My job was to report on any process that could be improved using Microsoft® Excel.

I’ll always remember asking one of the team (a “just-out-of-school” new recruit) what he was working on after I’d observed him sitting with a red biro and a ruler, diligently drawing red lines on 2 separate sheets of paper. It turned out he was trying to reconcile a customer’s account. Continue reading Excel – Using VLOOKUP to compare two lists

Excel – Retaining a leading 0 (zero) when entering Post Codes – great for mail merging

SharynAvatarBlog120x120PROBLEM: When you enter a post code that has a leading 0 (zero), e.g. 0642, you see only the last 4 digits, not the leading zero.  This is especially frustrating when using an Excel file in a Mail Merge!

SOLUTION: learn how make the 0 stay!

 

Continue reading Excel – Retaining a leading 0 (zero) when entering Post Codes – great for mail merging