Your Vlookup Function In Microsoft Excel May Not Be Working For A Few Reasons.


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”

Excel-Computer-Courses-Sydney

Related Topics

How to create a vlookup

How to keep the same cell reference – Absolute Cell Referencing

Naming cells in Excel

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

About Customised Computer Courses Sydney - Sutherland Shire M 0414 417 059

On-Site customised computer training courses Sydney - Sutherland Shire. Excel, Word,Power Point, Access, Outlook, Visio, Publisher, Excel VBA e: Info@azsolutions.com.au m: 0414 417 059 www.azsolutions.com.au
This entry was posted in Excel and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s