excel training course - Look Up

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

Resolved · Low Priority · Version Standard

Look Up

Trevor has attended:
Excel Advanced course

by - delegate Trevor [1 post] (2007 Jun 29 Fri, 14:10) Reply

If a policy number in a list of lookup data is repeated how can I get the system to give me the results (say a premium)of both when using Vlookup or is there some other formula that I can use

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	3	book now	£475	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	5	book now	£450	£485
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	5	book now	£450	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	7	book now	£345	£399
2003	2008 Oct 23 Thu + 24 Fri	Southwark	5	book now	£450	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: Look Up

by - trainer Amanda platinum contributer [947 posts] (2007 Jul 5 Thu, 16:05) Reply

Hi Trevor

Thanks for your question.

I'm not sure you could do this without writing code.

Would using the AutoFilter not suffice for what you are wanting to do?

Amanda

· Microsoft Excel Training: Essential for Today's Employees
· Microsoft Excel Features and Functions for Accountants
· Prepare for your MOS Certification with MS Excel Courses
· How to Create Better Excel Spreadsheets: Part One
· Fun Things I've Done With Excel