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

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

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

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)

"Kathleen V" <Kathleen wrote in message
...
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