excel computer training london - vlookup function
Microsoft Office Training verified by visa - mastercard securecode about microsoft training company london ukadd this page to your favourites/bookmarksAdd to favourites
view a printable version of this pagePrintable version
email this page to somebodyEmail this page
Customer: Sign in
Delegate: Sign in
Trainer: Log in
Home Course details Training formats Pricing FAQ Clients Book online Online schedule (live) Forum Contact us

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel computer training london - VLOOKUP function

excel computer training london - VLOOKUP function

The UK's most regular instructor-led training courses.
Training information: excel computer training london, Microsoft+excel+training, Microsoft Excel Training London · Microsoft courses.

resolvedResolved · Low Priority · Version Standard

VLOOKUP function

Katie has attended:
Excel Advanced course

by - delegate Katie [1 post] (2006 Dec 14 Thu, 10:24) replyReply

I'm having some trouble with VLOOKUP. It doesn't seem to work unless the data table it is reading from is in alphabetical/numerical order.... but I'm sure this can't be right!

Excel VBA 2 day course List price £495
Version Date Location Places
available
Book Next place rate:
Card Invoice
2003/XP 2008 May 15 Thu + 16 Fri Bloomsbury 4 book now £475 £485
2003/XP 2008 May 22 Thu + 23 Fri Southwark 5 book now £450 £485
2003/XP 2008 Jun 5 Thu + 6 Fri Bayswater 7 book now £345 £399
2003/XP 2008 Jun 12 Thu + 13 Fri Bloomsbury 6 book now £450 £485
2003/XP 2008 Jun 19 Thu + 20 Fri Southwark 7 book now £345 £399
2003/XP 2008 Jul 3 Thu + 4 Fri Southwark 6 book now £450 £485
Full Schedule: See all 66 Excel VBA course dates.
Bookings currently available until 26th November 2009.

RE: VLOOKUP function

by - trainer Amanda platinum contributer[689 posts] (2006 Dec 14 Thu, 14:52) replyReply

Hi Katie

Thanks for your question.

I think the answer lies in what you enter in for the 'range lookup' part of this function. This is the last part of the function where you enter in true or false.

If you enter in true for this part of the function, then the vlookup function will find the nearest possible match and display this. If you use true then the result that is displayed does depend on how the information is sorted - you do need to put it in some kind of order (alpahabetical or numerical) for it to work.

If you enter false for this part of the function, then the vlookup function needs to find an exact match. If you enter false then the result is not dependant on the information being sorted in a particular order.

I hope this helps you.

Amanda


Related articles

· Microsoft Excel Training: Essential for Today's Employees
· Identifying Suitable Candidates For VBA For Excel Training
· Microsoft Excel's Best Kept Secret
· An Introduction to Microsoft Excel: Top Features for the Excel Novice
· How to Create Better Excel Spreadsheets: Part Four

Excel tip:

Create a unique items table from a duplicating table

1. Ensure that your list has column headings
2. Select the entire list
3. From the menu bar, select DATA, FILTER, ADVANCED FILTER
4. Select "Filter the list, in place", and tick the "Unique Records Only" box
5. Click OK, filtered list appears.

View all Excel hints and tips

Institute of IT Training - Accredited Training Provider Institute of IT Training - Accredited Training Provider Prodigy Platinum Learning Partner Microsoft Office Specialist Authorised Testing Centre

Microsoft Registered Partner
microsoft office
ms office project server

Association of Computer Trainers Valid HTML 4.01 Transitional
Valid CSS Markup

secure online payments - visa - mastercard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Training by application Main information pages See also

Access courses
DreamWeaver courses
Excel courses
MS Project courses
Outlook courses
PowerPoint courses
VBA courses
Word courses
(more...)

Public scheduled courses
On-site training
Closed company courses

Microsoft Office training
Pricing and availability
Training schedule
Training venues

Access training
Dreamweaver training
Excel training
MS Project training
PowerPoint training

London Computer Training
Computer Training London

Microsoft Access training
Microsoft Excel training
Microsoft Project training
Microsoft Outlook training
Microsoft Powerpoint training
Microsoft Word training

Time Management Course London

Interested in Access training? Please see the following pages:
microsoft access courses · microsoft training access course
microsoft+access+training · access courses in london

Training Information