EXCEL - IF FUNCTION AND LOOKUP

%3CLINGO-SUB%20id%3D%22lingo-sub-2409145%22%20slang%3D%22en-US%22%3EEXCEL%20-%20IF%20FUNCTION%20AND%20LOOKUP%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2409145%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BI%20am%20unable%20to%20use%20the%20if%20function%20to%20do%20lookup%20of%20numbers%20greater%20than%209.%20For%20eg%20when%20I%20do%20the%20lookup%20for%20the%20number%2015%20in%20my%20file%20%2C%20it%20only%20does%20a%20lookup%20of%20what%20is%20in%2015%20but%20also%20what%20is%20in%201%20and%205.%20Any%20idea%20why%20this%20happens%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2409145%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello ,

           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?

1 Reply
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.