98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Vlook up returning multiple values
Vlook up returning multiple values
Resolved · High Priority · Version 2003
Julie has attended:
Excel Advanced course
Vlook up returning multiple values
Hi,
I have created a spreadsheet to record training in our company. I have created a look up function to search on employee name to return the department, traininf course and cost. Obviously this will only returnt one entry and an employee may attend more than one course in the year. I looked on the web and follow the instructions to create this formula; =INDEX($A$14:$J$109,SMALL(IF($A$14:$A$109=$A$4,ROW($A$14:$A$109)),ROW(1:1)),2) but it returns an #value error. I investigated further and it seems to be to do with the formatting. Some of the results will be in text and some in numbers so I tried to change the format of the cells but I still get this error.
can you please help?
Thanks
Julie
RE: Vlook up returning multiple values
Hi Julie
Thank you for your question.
If the lookup value is a person's name, maybe that is causing the problem? Are you putting the person's name inside double quotation marks " "?
Amanda
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:Recently used file listUnder the File menu, you may find a list of files at the bottom of the menu. These files represent the most recently used Excel spreadsheets. This file list provides a quick way for you to access your files. |