Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

vlookup

ResolvedVersion Standard

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

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

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.