Solved

Excel VLOOKUP problem

Posted on 2015-02-02
7
151 Views
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
articles.xlsx
0
Comment
Question by:gadsad
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 250 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)
0
 
LVL 11

Assisted Solution

by:Wilder1626
Wilder1626 earned 250 total points
ID: 40584323
Here you go with TRIM values in sheet1, and also updated the VLookup
=VLOOKUP(A2,Feuil1!A:B,2,0)

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.
articles-1.xlsx
0
 

Author Comment

by:gadsad
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
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 
LVL 11

Expert Comment

by:Wilder1626
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.

Thanks
0
 
LVL 50

Expert Comment

by:Ingeborg Hawighorst
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.
0
 
LVL 24

Expert Comment

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

Author Closing Comment

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

And it worked fine

Thank you very much
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

773 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