View original (French)

Subtract from a vlookup

Solved
sioum -  
 sioum -
Hello,

here is my issue with Excel, I made a function =if(isna(vlookup... which works very well except that in the result I would like to subtract another number...

where should I place this subtraction? or how should I proceed?

Thank you very much for your responses.
Configuration: Windows XP Internet Explorer 6.0

3 answers

  1.
    wilfried_42 Posted messages 912 Status Contributor 245
     
    Hello

    difficult without the complete formula and 2 or 3 additional pieces of information

    only hint:

    =if(isna(vlookup(....................));""; vlookup(..............) - 10%)

    --
    Best regards
    Wilfried

    ps: don't forget to mark your thread as resolved when you find what you're looking for. Thank you
    0
  2. sioum
     
    Voici la traduction de votre texte :

    Here is my formula in raw form

    =IF(ISNA(VLOOKUP("TOTAL 20510009", 'GL CPTE 20-21.2008'!$A$5:$J$38, 9, 0)); ""; (VLOOKUP("TOTAL 20510009", 'GL CPTE 20-21.2008'!$A$5:$J$38, 9, 0)))

    Here is my simplified formula:

    =IF(ISNA(VLOOKUP(....................)); ""; VLOOKUP(..............)))

    I would like to subtract a cell from this, it would look like this if it were possible:

    =IF(ISNA(VLOOKUP(....................)); ""; VLOOKUP(..............)) - D8

    Thank you for responding
    0
  3. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Good evening
    Logically, according to your explanations (?), it should be enough to enclose the entire second item of your formula in parentheses
    that is, one immediately after the semicolon separating the ISNA part from the lookup part and one at the end of the formula and the other after the subtraction
    =$IF(ISNA(VLOOKUP(........);"";(VLOOKUP(......................)-your number)
    Best regards

    --
    The truth is not possessed; it is only sought.
    0
    1. sioum
       
      I tried but it doesn't work

      a small but significant clarification is that in the cell I named D8
      the cell to subtract also has a formula.

      that said, I still tested by replacing the formula in D8 with a number but
      it still doesn't work either.
      0
    2. sioum
       
      In testing your proposal, it indicates

      #VALUE
      0
      1. sioum > sioum
         
        I solved my problem

        I had to place a 0 in the middle of the formula:

        formula before:

        =IF(ISNA(VLOOKUP(....................)); ""; VLOOKUP(..............)))-D8

        formula after:

        =IF(ISNA(VLOOKUP(....................)); "0"; VLOOKUP(..............)))-D8


        There you go, thank you

        goodbye
        0