Vlook up returning multiple values

The UK's most regular instructor-led training courses.
Training information: microsoft-excel-training · Excel courses · Microsoft Excel Training UK
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · High Priority · Version 2003

Julie has attended:
Excel Advanced course

by - delegate Julie [2 posts] (2008 Apr 16 Wed, 13:24) Reply

Hi,

I have created a spreadsheet to record training in our company. I have created a look up function to search on employee name to return the department, traininf course and cost. Obviously this will only returnt one entry and an employee may attend more than one course in the year. I looked on the web and follow the instructions to create this formula; =INDEX($A$14:$J$109,SMALL(IF($A$14:$A$109=$A$4,ROW($A$14:$A$109)),ROW(1:1)),2) but it returns an #value error. I investigated further and it seems to be to do with the formatting. Some of the results will be in text and some in numbers so I tried to change the format of the cells but I still get this error.

can you please help?

Thanks
Julie

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003/XP	2008 Jul 17 Thu + 18 Fri	Bloomsbury	3	book now	£475	£495
2003/XP	2008 Jul 30 Wed + 31 Thu	Bayswater	5	book now	£450	£485
2003/XP	2008 Aug 7 Thu + 8 Fri	Bloomsbury	6	book now	£450	£485
2003/XP	2008 Aug 14 Thu + 15 Fri	Bloomsbury	5	book now	£450	£485
2003/XP	2008 Aug 26 Tue + 27 Wed	Bayswater	6	book now	£450	£485
2003/XP	2008 Sep 8 Mon + 9 Tue	Bayswater	7	book now	£345	£399
Full Schedule: See all 48 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Vlook up returning multiple values

by - trainer Amanda platinum contributer [830 posts] (2008 Apr 25 Fri, 16:45) Reply

Hi Julie

Thank you for your question.

If the lookup value is a person's name, maybe that is causing the problem? Are you putting the person's name inside double quotation marks " "?

Amanda

· Benefits of learning about Excel charts
· How Excel Training Can Improve Your Company's Sales Process
· How to check for and reduce errors in Microsoft Excel
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers

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