Vlookup If Statement

[mwgr5]

I am using a vlookup in an if statement. The formula is =IF(VLOOKUP(A19,U1:V8,2,0)=O19,"TRD",1). Basically, the formula says if the number in cell O19 is equal to a number found by the vlookup, return TRD, if not return 1.

The formula works if O19 is actually a number. However, 019 references another cell in a differnt worksheet. The cell referenced is actually another formula.

Is there a way to have excel recognize O19 as a number instead of a formula?

Thanks.

[NBVC]

if the result in O19 is a number, then it should still work... unless perhaps it is not a whole number and then we may have precision issues. Is that perhaps the case?

[mwgr5]

It is not a whole number, but the numbers are all simple, like .4, .3, etc, nothing over two decimals.

[NBVC]

Does this work?

=IF(VLOOKUP(A19,U1:V8,2,0)=TRUNC(O19,1),"TRD",1)

[mwgr5]

That works well! Thanks for the help!

[NBVC]

Then that means, the result of the formula is not really only 1 decimal place...it may be formatted to appear so, but isn't actually.