I am unable to use the if function to do lookup of numbers greater than 9. For eg when I do the lookup for the number 15 in my file , it only does a lookup of what is in 15 but also what is in 1 and 5. Any idea why this happens?
If you want more than random guesses, it would help us help you if you posted a copy of the formula you're referring to. And maybe even a copy of the full spreadsheet (Not just an image) where it occurs.