Vlookup Problem

[Ponto]

Hi,

I have a Vlookup problem.

=IF(ISBLANK($B14)=TRUE,"-",VLOOKUP(B14,'[Tarif pièces détachées-Spare parts price list 2015-V2.xlsx]Tarif 2015 '!$A$1:$B$65536,2,FALSE))

my formula is working and returning a value and in 95% of the times it is correct.

It has specific problem when looking at the following data.

VTRCC10*140
VTRCC10*150
VTRCC10*160
VTRCC10*180
VTRCC10*200
VTRCC10*25
VTRCC10*30
VTRCC10*40

So when I search for the VTRCC10*40 it returns the value associated with the line of VTRCC10*140

I have tried sorting the data but this doesn't make any difference.

 

[shuklaankur281190]

If you are using above formula it should given #N/A or exact match,,,, but you are speaking that it is giving you VTRCC10*140 second column value...... seems either you are putting approximate value (True) or may be you are putting wrong formula for that thing .. once pls send me your file on my mail id shukla.ankur281190@gmail.com