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
Charla74's avatar
Charla74
Iron Contributor
Mar 21, 2020

DDannies 

 

The VLOOKUP looks fine and should work - Try a quick test formula; =B6=H3

If the answer is FALSE then the values are not the same and that explains the fail.

DDannies's avatar
DDannies
Copper Contributor
Mar 21, 2020

Charla74 no I got true when I did that.

Resources