#Value issues

[citadel_87]

I know the issue is that I am looking at text as well as using numeric operators. I hope someone can help me get around this problem.



[TABLE="width: 75"]
<colgroup><col width="75"> </colgroup><tbody>[TR]
<!--StartFragment--> [TD="class: xl24, width: 75"]=IF(VLOOKUP(I23,Formulas!$A$7:$G$52,3)>0,X23-VLOOKUP(I23,Formulas!$A$7:$G$52,3),"N/A")[/TD]
<!--EndFragment--> [/TR]
</tbody>[/TABLE]

 

[Jonmo1]

Can you give some examples ?

What is in X23, and what is the result of the Vlookup?

What do these return
=ISNUMBER(X23)
=ISNUMBER(VLOOKUP(I23,Formulas!$A$7:$G$52,3))

 

[citadel_87]

x23 is a date or "N/A"


Vlookup is pulling number of days for a given vendor delivery date. Some vendors the number of days do not apply.