Vlookup and left - works with all apart from 93% and 112%

[Guest]

Hi,

I have a problem with a vlookup formula that also uses the left-formula.
E.g. the data in A1 is 96.35%

the formula is: Vlookup(Left(A1,4)*1+0.01,Mydata,2,false)

Mydata is a list of all percentages ranging from 80%-200% in the first
column.

This formula works with the percentage in A1 above, but when I change the
formula to 93% or 112% (with or without 2 decimals), I get #N/A. Why does the
formula give an error on only those 2 percentages?

thanks
kathleen

 

[Bob Phillips]

TRy

=Vlookup(Round(Left(A1,4)*1+0.01,2),Mydata,2,false)


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Wow - it really ia that simple - it works!! Many thanks!!