Forum Discussion

1039544's avatar
1039544
Copper Contributor
Jul 27, 2024
Solved

VLOOKUP

Hi there,   I was making an automated nutrition plan and I've been struggling with this one problem for a long time now...   Whenever I use VLOOKUP and try to multiply it with another cell, it gi...
  • Riny_van_Eekelen's avatar
    Jul 27, 2024

    1039544 Since you are using Dutch Excel, you need to use commas for the decimal indicator. Now, all your 'numbers' ar texts except the few "0,0" that are right-aligned and visible in the screenshot . Use Find & Replace (ctrl-H) and replace all dots (period) with commas and that should resolve the issue.

Resources