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 » vba-excel-training - Look-ups
vba-excel-training - Look-ups
Resolved · Low Priority · Version Standard
Mon 21 Jan 2008, 17:04Delegate Mia said...
Tue 22 Jan 2008, 16:11Delegate Paul said...
RE: Look-ups
Make sure your list is set up nicely.
VLookup can't look left, so if you have a list containing first name, last name, telephone number and userID in that order and you will be doing a VLookup to return the last name based on the userID, you'll have to have the userID more to the left than the last name, if you get my drift..
So your list should be userID, first name, last name, telephone number now.
Otherwise you will be looking at using the index() and match() formulae together as array entered formulae (don't ask!), which is difficult to enter these formulae and clogs up your system a fair bit too.
Hope this helps
Paul
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:Shortcuts for working with named ranges in ExcelIf you are working with or creating named ranges in your spreadsheets, then you may find the following shortcut keys useful. |
