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

vlookup

ResolvedVersion 2003

Roxanne has attended:
Excel Advanced course

Vlookup

What if there are 2 possible return values i.e 2 Jone's within the vlookup criteria

RE: vlookup

Hi
If the item you are looking up is not unique then VLookup would not be suitable... For example, if your list contains names of clients that appear multiple times in the list such as Smith or Jones, then using a Lookup function to look up Smith, will look down the list and stop and return info for the first Smith it arrives at!

Hope that helps

Mark

Thu 16 Sep 2010: Automatically marked as resolved.

Excel tip:

Autosum shortcut key

press ALT + =

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.12 secs.