Solved

Problem with Lookup with special character (+)

Posted on 2014-10-16
2
124 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 22

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Calculating Standard Deviation inside Excel. 5 119
To array or not to array 11 75
Turn date into age 17 40
Conditional Formatting Formulas 7 43
Last month, Google released a new update for Google Sheets. This new update offers new ways to visualize and analyze data. Use this article to learn how to take advantage of the new tools now available for charts, cells and collaboration with Google…
With voice direction tools, various map viewing styles, the ability to get directions for different means of transportation and great service, Google Maps is simply one of the best navigations app in the market.    However, over the past year, an …
This Micro Tutorial demonstrates the importance of annotations in Google Analytics and how they should be used to document changes made to a site, Google updates (Ex: Panda & Penguin), marketing campaigns, and any other events that might have contri…
This Micro Tutorial will demonstrate Google Calendar to monitor updates with top sites, such as Facebook, Google, Twitter, etc. with Marketing News. Each update of Google Calendar can be monitored, correlate dips and spikes in your website traffic, …

730 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