Location Of Lookup Value
When cross matching data and extracting information from a particular column use Vlookup. However there are times when a Vlookup won’t do the job because it can only look to the right for the data to extract. If the lookup value in the Master List (Table) is located somewhere in the middle and you find your self cutting and pasting the lookup value to the first column of the table. That’s when you will need to use Index and Match function instead.
Lookup Value Formatting
An other reason why your Vlookup function may not be working is because in you table the lookup value is formatted for number and in the other area it is formatted as text or there is an extra space at the end. To get rid of the extra space try the TRIM function.
What you can do to make your Vlookup function in Microsoft Excel so much easier to read is to use Range Names. Instead of selecting the Sheet and then the Master Data use a Range Name. You can also use Range Names in Data Validation Lists.
Visit my bog on “How To Create A Vlookup”
How to keep the same cell reference – Absolute Cell Referencing
Microsoft Office Small Group Training Sessions
AZ Solutions Pty Ltd delivers customized training courses here in Sydney – Australia. We come to you. All you need is a board room, PC’s for each student and a TV/ Projector with a HDMI connection cable. In our training sessions you are welcomed to bring examples of your work to class. We prefer it.
Call Now M 0414 417 059 visit www.azsolutions.com.au