Forum Discussion

DDannies's avatar
DDannies
Copper Contributor
Mar 21, 2020

VLOOKUP Function failed - although everything is correct ?

  RowIndex              B C D E  F 2 Price  Fruit  Quantity  Price Value  3  23  Banana  50  0,4  1,00 €  4  34  ...
excel
  • DDannies's avatar
    DDannies
    Copper Contributor
    Mar 21, 2020

    SergeiBaklan here my proof that I still get an error when I do the same as you

  • DDannies's avatar
    DDannies
    Copper Contributor
    Mar 21, 2020

    SergeiBaklan not by me when I do the same, so my mistake must have another origin . I am totally new to Excel in general.

  • Charla74's avatar
    Charla74
    Iron Contributor
    Mar 21, 2020

    SergeiBaklan 

     

    I also got it working by typing in the formula, rather than selecting cells / ranges:

     

    =VLOOKUP($H$3,$B$2:$F$11,2,0)

    • DDannies's avatar
      DDannies
      Copper Contributor
      Mar 21, 2020

      Charla74  here is my file when i do the same - still get an error

Resources