Hi Parker

i'm a bit confused - firstly as in your example you have
B2, C3, D2
do you mean B2, C2, D2 ???

secondly, when i assume you mean B2, C2, D2, when i fill down to C3, D3 i
get
0.0405 in C3 - which returns a #N/A error - which is expected as this value
is not in column I

have i mis-understood the example or the problem?

Cheers
JulieD

"Parker" wrote in message
...
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(C25%,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