Forum home » Delegate support and help forum » Microsoft Excel Training and help » VLOOKUP

VLOOKUP

ResolvedVersion Standard

Fri 7 Mar 2008, 15:43 Delegate Michael said...

Michael has attended:
Excel Advanced course

VLOOKUP

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

Sun 9 Mar 2008, 11:18 Trainer Cress said...

RE: VLOOKUP

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

Training courses

98.6 % recommend us

More live stats...

Training information:

Excel tip:

Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

View all Excel hints and tips