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.

Resolved · Low Priority · Version Standard

VLOOKUP function

Katie has attended:
Excel Advanced course

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

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!

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course				List price £495
Version	Date	Location	Places available	Book	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) Reply

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

· 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

secure online payments - visa - mastercard

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

Training by application

Main information pages

excel computer training london - VLOOKUP function

Related articles

Excel tip:

Create a unique items table from a duplicating table