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

macros

ResolvedVersion 2003

George has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Macros

What is the best formula to use for a double Vlookup on two criteria?

RE: Macros

See this link for an explanation using MATCH and INDEX

http://skp.mvps.org/xl00002.htm

Janet

Mon 15 Dec 2008: Automatically marked as resolved.

Excel tip:

Repeat action

The F4 key will usually repeat your last action. e.g. delete a row, then select another row and press F4 to delete again.

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.