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.