I'm using Office 2000 Professional and I have a vlookup function that works

in most cases, but not for some. I have a formula for a discount factor and

a formula that rounds that factor to the nearest 0.5%. I then look up that

result in a table but there are six values that it does not find (-17.5%,

-20.5%, -23.5%, -28.5%, -34.5% and -35.0%) Any ideas why it cannot find

these certain values in the lookup range and is there any way to fix this?

To see the problem, put the following info & formulas into a blank worksheet:

Cell A1 - "11111"

Cell A2 - "-500"

Cell A3 - "-450"

Cell B2 - "=A2/A$1"

Cell C3 - "=IF(B2<0,MROUND(ABS(B2),0.005),-MROUND(B2,0.005))"

Cell D2 - "=IF(C2>5%,18.5%,IF(C2<-40%,0, VLOOKUP(C2,I$2:J$92,2,FALSE)))"

Copy cells B2 thru D2 down one line

Fill Down A2 to D3 thru row #102

Cell I2 - "5.0%"

Cell I3 - "4.5%"

Cell J2 - "18.250%"

Cell J3 - "18.125%"

Fill Down I2 to J3 thru row #92

Thanks in advance for any help,

Parker

## Bookmarks