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?
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
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.
