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?
Bookmarks