function error?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
Back
Top