Your Vlookup function in Microsoft Excel may not be working for a few reasons.


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

You will need to use an Index function together with a match.

If this sounds like the solution you need, book into our 2 hr training session Index Match – Absolute course.

Excel-Computer-Courses-Sydney

If you are still struggling AZ Solutions Pty Ltd provides Customized Face to Face training in Sydney – Australia.

Related Topics

How to create a vlookup

How to keep the same cell reference – Absolute Cell Referencing

Naming cells in Excel

 

Advertisements

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. 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 )

w

Connecting to %s