asked on

Excel VLOOKUP problem

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

ASKER CERTIFIED SOLUTION

Phillip Burton

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Wilder1626

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Gad SAADIA

ASKER

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

Wilder1626

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

Ingeborg Hawighorst (Microsoft MVP / EE MVE)

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.

Phillip Burton

Have you seen my answer?

Gad SAADIA

ASKER

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

And it worked fine

Thank you very much