Home » Our Blog » VLOOKUP

Tag: VLOOKUP

Excel – Using VLOOKUP to compare two lists

sharyn bainesIf you want to save yourself a huge amount of time when reconciling data, learn how to use VLOOKUP to compare two lists or columns of data.

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. Read more

Excel – Paste a link and Paste Special transpose your data

Without a doubt ‘Paste Link’ is one of the best time-saving features in Excel.  Linking information from one cell to another saves you from having to update data in several places.

Another fabulous time-saving feature is ‘Paste Special Transpose’. This allows you to copy a horizontal range and paste it vertically, or vice versa. An absolute gem.

But have you ever tried to use the two together?  It isn’t easy at all.  In this post I want to share a wee work-around that will allow you to use the Paste Link and Paste Special Transpose features together. Read more