function error?

[George_at_Chase]

Here I find one thing I can't explain, i use vlookup to find numbers and
compare them, say cell1=VLOOKUP(R263,FR30BUD,2), and
cell2=VLOOKUP(R263,SVC30Mlti,2), where the FR30BUD and SVC30Mlti are names of
ranges. then I use "=cell1>cell2" in cell3, the strange thing is even if
cell1 is less than cell2, I still get "true". the value in these ranges are
all numbers.

I wonder what's wrong here?

Thank you.

 

[Max]

The vlookup returns are probably text numbers

Try add a zero to coerce these to real numbers, eg:
cell1=VLOOKUP(R263,FR30BUD,2)+0
cell2=VLOOKUP(R263,SVC30Mlti,2)+0

The above should clear up your comparison in cell3 (=cell1>cell2)