VLOOKUP

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

Resolved · Low Priority · Version Standard

VLOOKUP

Michael has attended:
Excel Advanced course

by - delegate Michael [1 post] (2008 Mar 7 Fri, 15:43) Reply

Hi All,

Vlookup and Hlookup return the first entry that matches the criteria how do we return the second/third/etc.?

Thank you.

Sincerely,

Michael

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Sep 4 Thu	Bayswater	4	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
2003	2008 Sep 11 Thu	Southwark	4	book now	£207	£215
Full Schedule: See all 137 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: VLOOKUP

by - trainer Rich platinum contributer [711 posts] (2008 Mar 9 Sun, 11:18) Reply

I assume you are using something like the following formula:

=VLOOKUP(D2,Range1,1,FALSE)

Where it says 1 (after the Range1) then you need to change this to 2/3 etc as this is the column number so for example:

=VLOOKUP(D3,Range1,2,FALSE)

When using a range all columns must exist in your range

· What's Better Than the Help Function in Excel? Microsoft Training
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Microsoft Excel Training: Essential for Today's Employees
· Basic Excel Training
· How to Create Better Excel Spreadsheets: Part One

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

Excel tip:

Difference between Two Dates

The DATEDIF function computes the difference between two dates. The DATEDIF function is as follows:

=DATEDIF (Date1,Date2,Interval)

Please note that Date1 must be less than (earlier) or equal to Date2

Please note that Interval must be one of the following codes: "d" (in days), "m" (in months), "y" (in years) expressed in quotes

View all Excel hints and tips