vlookup
The UK's Number 1 for Microsoft Office Training
Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Vlookup

Recommend training98.1 %
recommend us
More live stats...

The UK's most regular
instructor-led training courses.

Training information:

See also:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

See also:
Hints and tips
Forum topics

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Vlookup

resolvedResolved · Low Priority · Version 2007

replyReply Mon 14 Nov 2011, 16:06Delegate Jason said...

Jason has attended:
Excel Advanced course

Vlookup

Basic V lookups ae fine but say if you want to look up different pages. Say you have an ID. And that ID represents different things in different formats, COuld you collate it in one vlookup.

For upcoming training course dates see: Pricing & availability

replyReply Thu 17 Nov 2011, 16:22 Edited on Thu 15 Mar 2012, 11:00Trainer Paul said...

RE: Vlookup

A vlookup will look up the table and column that you tell it to look up. It will not look up mufti tables. Is that what you are asking?

Wed 23 Nov 2011: Automatically marked as resolved.

 

Excel articles

· Customize Your Gridlines And Borders In Excel 2007
· Securing Critical Company Information With Simple Visual Basic Training Courses
· The Best Way To Use Clip Art Images In Excel
· How To Manage Your Everyday Spending In Excel
· Identifying Suitable Candidates For VBA For Excel Training

Please browse our web site to find out more about
excel training class and other Microsoft training courses.

Excel tip:

Viewing Many Worksheets

If there are more worksheets in your workbook than there is room to show all their tabs at the bottom of the screen - Right click on the navigation arrows. A list of all your worksheets is shown. You just click on the one that you want to access. If you have more than 15 worksheets, select in the list and choose your worksheet from hundreds.

View all Excel hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. infomst
All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy