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

vlook up

ResolvedVersion 2010

Allison has attended:
Excel Intermediate course

V-Look up

What is the easiest way to remember how to do this?

RE: V-Look up

Hello Allison,

Easy way to remember, what you are looking up must be unique (no duplicates), and the info required to return to you must be in a column to the right of the lookup column.

the VLOOKUP 4 attributes are as follows:

VLOOKUP(What are you looking for?, Where will you find it? Once found how many columns to count to the right, Exact match required)

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Mark
Microsoft Office Specialist Trainer

Mon 26 Dec 2011: Automatically marked as resolved.

Excel tip:

Trace Dependents / Precedents without the blue arrows

Rather than using the toolbar you can press CTRL+] which is the equivelent of trace dependants and CTRL+[ for precendants. Both of these ways though will not show the blue arrows but jump to the cell containing the formula.

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.