Forum Discussion

sanjay_v_m's avatar
sanjay_v_m
Copper Contributor
Jun 02, 2021

EXCEL - IF FUNCTION AND LOOKUP

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?

Formulas and Functions

1 Reply

  • mathetes's avatar
    mathetes
    Silver Contributor
    Jun 02, 2021
    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.

Resources