Vlookup not working?


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.

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.

Related Topics

How to create a vlookup

How to keep the same cell reference РAbsolute Cell Referencing

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s