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 2010
Fri 19 Sep 2014, 15:48Delegate D said...
D has attended:
Excel Introduction course
Excel Advanced course
Vlookup
if the lookup value is from a different sheet to the lookup range, how do we ensure the formula works? i.e. the cell contents may look to same to us but might not be. So quite often, the lookup fails. any solutions?
Mon 22 Sep 2014, 11:50Trainer Cindy said...
RE: Vlookup
Hello Deepa,
Thank you for your question.
There are a couple of functions that will help, Trim and Clean.
Trim removes all spaces from text except for single spaces between words.
Clean removes all non-printable characters from text.
Here's an example of the trim function nested inside a vlookup:
=VLOOKUP(TRIM(A2),Products,2,FALSE)
Here's an example of the trim and clean functions nested inside a vlookup:
=VLOOKUP(TRIM(CLEAN(A2)),Products,2,FALSE)
I hope that helps. Feel free to response if you want further clarification.
Kind regards
Cindy
Microsoft Office Trainer
Wed 26 Nov 2014, 11:43Trainer Jens said...
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Tue 2 Dec 2014: 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:Paste with Live Preview in Excel 2010Did you know you can preview what you are about to paste? Here's how to do it. |
