98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Vlookup
Vlookup
Resolved · Medium Priority · Version 2003
Mon 6 Sep 2010, 16:02Delegate Roxanne said...
Roxanne has attended:
Excel Advanced course
Vlookup
What if there are 2 possible return values i.e 2 Jone's within the vlookup criteria
Fri 10 Sep 2010, 10:55Trainer Mark said...
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.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Create Charts with One keystrokeCreate a graph with one click |
