Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel classes - V Lookup's

	98 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel classes - V Lookup's

Resolved · Low Priority · Version Standard

Reply Fri 1 Feb 2008, 16:41Delegate James said...

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

V Lookup's

If v looking up a list of numbers what if my lookup value is duplciated?

For upcoming training course dates see: Pricing & availability

Reply Mon 4 Feb 2008, 16:41Delegate Paul said...

RE: V Lookup's

vlookup looks for a unique value and returns a relevant piece of data.

You would need something that makes the value unique, like a specific pupil ID

if your values are all duplicates, you should make your own little unique reference.

something like a date entered combined with the order number would be good by usig the concatenate() function.

Excel articles

· Find Out Your Age In Days With Excel
· Some Interesting Finds In Excel 2007/2010 Using Find And Select
· How To Take Your Data Out Of The Shade
· Creating Tables Automatically In Excel 2010
· Inviting Investment Into Your Business Can Be Easier With Excel

Excel tip:

LARGE and SMALL functions and their uses

Two of Excel's most common functions are the MAX and MIN functions which will display the largest (MAX) or smallest (MIN) value in a series. What if you need the 2nd or 3rd largest or smallest values instead of the largest or smallest?

The =LARGE(array,n) returns the nth largest value of a series.

The =SMALL(array,n) function returns the nth smallest value of a series.

In both functions, 'n' represents the order of the number you want to display. For example, putting in 2 as n will give you the second highest number; putting in 3 as n will give you the third highest number.

View all Excel hints and tips