Solved

Problem with Lookup with special character (+)

Posted on 2014-10-16
2
114 Views
Last Modified: 2014-11-12
I am trying to do a lookup but my data includes a special character - a plus +

In Excel it is erroring and in Google Sheets, it is causing further issues with wrong values being returned.

I have uploaded a spreadsheet which shows the issue.

Column D is devised by looking for column F in A and returning value in B

Thanks

Aidan
lookupIssue.xlsx
0
Comment
Question by:aideb
2 Comments
 
LVL 21

Accepted Solution

by:
Ejgil Hedegaard earned 500 total points
ID: 40384737
Use this formula
=VLOOKUP(F2,A:B,2,0)
0
 
LVL 2

Author Closing Comment

by:aideb
ID: 40384945
Brilliant! Thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of my favorite tools to use with Google Drive is the offline access. Setting up offline access for Google Drive makes it easier for users to edit and view their docs, sheets and slides without Internet connection. Follow these steps to learn how…
The choice of selecting a perfect productive suite for one’s organization is a critical decision that an IT Manager or a CIO has to make. And when it comes to choosing a cloud-based productivity suite, the choice gets all the more difficult. This is…
This Micro Tutorial will demonstrate how to analyze your website's back links using a network graph powered by a fusion table.
This Micro Tutorial demonstrates how to quickly find related content for YourTango's posts using MozBar Chrome extension.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now