Good day Demigods,
I have 10 rows that lookup their values from vlookup table depending on user selection.
These 10 rows are then SUM'd.
Because the values are from lookup tables, the SUM is giving an incorrect result.
When I enter the exact same values manually, the answer is correct.
I have checked all cells that are used in the lookup table and ensured formating is consistant throughout, i.e. set to Number, but still the same.
To solve the issue, I thought I could use the vlookup in an adjacent column to display the 10 rows and then have VBA copy the values from said column and paste as values in the actual column that they are needed in. My brain says that this should work and that it would result in SUM being calculated correctly.
However, I need help with the VBA, and this is where you mighty fine people take centre stage.
Alternatively, if there is a solution to the SUM issue, please feel free to share.
Any help is greatly appreciated and I thank you in advance for your time.
Yours sincerely
Manc
I have 10 rows that lookup their values from vlookup table depending on user selection.
These 10 rows are then SUM'd.
Because the values are from lookup tables, the SUM is giving an incorrect result.
When I enter the exact same values manually, the answer is correct.
I have checked all cells that are used in the lookup table and ensured formating is consistant throughout, i.e. set to Number, but still the same.
To solve the issue, I thought I could use the vlookup in an adjacent column to display the 10 rows and then have VBA copy the values from said column and paste as values in the actual column that they are needed in. My brain says that this should work and that it would result in SUM being calculated correctly.
However, I need help with the VBA, and this is where you mighty fine people take centre stage.
Alternatively, if there is a solution to the SUM issue, please feel free to share.
Any help is greatly appreciated and I thank you in advance for your time.
Yours sincerely
Manc
Last edited:
