Forum Discussion

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Feb 11, 2018

    Rien,

     

    Put this formula in cell C4:

    =VLOOKUP(B4,$E$4:$F$9,2,0)

    This is all you need!

    • Rien Stuijfzand's avatar
      Rien Stuijfzand
      Copper Contributor
      Feb 12, 2018

      Hello Haytham,

       

      Thanks very much for the help, it got me on the way.

      The correct formula for me ( Office Home and Student 2013) was:

      =VERT.ZOEKEN(B4;E4:F9;2;ONWAAR)

       

      I have the Dutch version... ;-)

       

      Again, thanks very much for putting me on the right track!!!

Resources