Forum Discussion

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

Diamond Contributor

Mar 21, 2020

Perhaps some of your values are texts and some are are numbers. Could you please share sample file instead of screenshot?

Copper Contributor

Mar 21, 2020

SergeiBaklan here is my file

excelfile.xlsx12 KB

SergeiBaklan
Diamond Contributor
Mar 21, 2020
DDannies

It works with

=VLOOKUP([@ID],Table1,2,0)

Please see attached
excelfile.xlsx20 KB
- DDannies
  Copper Contributor
  Mar 21, 2020
  SergeiBaklan here my proof that I still get an error when I do the same as you
- 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
  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
    Copper Contributor
    Mar 21, 2020
    Charla74 here is my file when i do the same - still get an error

Resources