98.8% 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 » V-Lookup
V-Lookup
Resolved · Urgent Priority · Version 2010
Wed 18 May 2016, 17:58Delegate Hai-anh said...
Hai-anh has attended:
Excel Advanced course
Excel Advanced - Formulas & Functions course
Excel Dashboards for Business Intelligence course
Influencing Skills course
Negotiating Skills course
V-Lookup
Hi,
Is there a way to do a V-LOOKUP with a combination of prefix letters with numbers that don't throw up error or #NA's?
Many thanks,
Hai-anh
Thu 19 May 2016, 08:54Trainer Jens said...
RE: V-Lookup
Hi Hai-anh,
Thank you for the forum question.
Yes.
You can concatenate character or use text functions depending on your data.
I have attached a workbook with some examples.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Attached files...
vlookup pre fix.xlsxThu 19 May 2016, 14:02Delegate Hai-anh said...
RE: V-Lookup
Thanks for this Lens, however I cannot see the file attached?
Regards,
Hai-anh
Thu 19 May 2016, 14:47Trainer Jens said...
RE: V-Lookup
Hi Hai-anh,
Please try to press F5 and you should be able to find the attached file just under the signature in my reply.
If you cannot find it please let me have your email address and I can send the workbook to you.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
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:Status Bar FunctionsWhen using the SUM, MIN, MAX, AVERAGE and COUNT functions, the result of such calculations are displayed in the worksheet. |
