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?

DDannies
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

Resources