Excel VLOOKUP problem

Posted on 2015-02-02
Medium Priority
Last Modified: 2015-02-02
Hello ,

can someone see  why the VLOOKUP formula in B2 does not work

It retreives the value of one line before the good one!! very very strange

In B2 for example it should retreive 27 and it retreives 26.

I have looked at everything without success

Sorry that it is in French

Thank you very very much
Question by:gadsad
  • 2
  • 2
  • 2
  • +1
LVL 24

Accepted Solution

Phillip Burton earned 1000 total points
ID: 40584311
There are two problems.

1. "Feuil1" column A has a space at the end of each number.
2. The VLOOKUP should have a ,FALSE or ,0 at the end.

I would suggest changing B2 to

=VLOOKUP(A2 & " ",Feuil1!A1:B7068,2,0)
LVL 11

Assisted Solution

Wilder1626 earned 1000 total points
ID: 40584323
Here you go with TRIM values in sheet1, and also updated the VLookup

Open in new window

I'm alwas fuzzy about empty spaces. never like them. always good to remove when you work with huge data file or data base.

Author Comment

ID: 40584508
Thank you so much for finding an empty space. I had never though about that

I tried to do =TRIM(A1) but instead of giving the correct value (000027 without trailing space) it just write in the worksheet =TRIM(A1). As if the function is not calculated

Strange again
Any idea ?

Thank you again
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

LVL 11

Expert Comment

ID: 40584515
It would be hard to tell. I did the trim on my end and it worked on my post: ID: 40584323

If it all worked, please make sure to accept the answer.

LVL 50
ID: 40584630
If the formula does not calculate the result, the cell is most likely set to Text. Change the cell format to General, then -- this is important -- edit the cell. and hit enter again. Now the calculated result should show and you can copy the formula down.
LVL 24

Expert Comment

by:Phillip Burton
ID: 40584927
Have you seen my answer?

Author Closing Comment

ID: 40585023
I used TRIM to remove last space and VLOOKUP with a FALSE

And it worked fine

Thank you very much

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In this article, I will demonstrate that how to do a PST migration from Exchange Server to Office 365. This method allows importing one single PST, or multiple PST's at once.
With the emergence of Office 365 as a superior email communication platform, many organizations have started switching over to it.  After migrating to Office 365, sometimes users, as well as organizations, will have to import PST files to Office 36…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

607 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