Output number as a number, not text

[Ocean Zhang]

I have an "if" formula where if false, the output is "1". But that "1" is coming up as text.

here's the formula:

=IF(ISNUMBER(VLOOKUP(A2,'sheet2'!A:S,19,FALSE)),VLOOKUP(A2,'sheet2'!A:S,19,FALSE),"1")

Then when I reference that result in another formula that is dependent on whether or not a cell is greater than 1, it thinks the result from the above formula is greater than 1. How can I make the above formula output a number for 1 instead of text of 1?

[icestationzbra]

just remove the quotes that you have placed around 1. quotes are turning the number into a text string.

[Ocean Zhang]

holy crap I'm stupid lol

thanks for the tip