VLOOKUP SUM not getting correct values

asked 2018-08-08 02:50:08 +0200

josef gravatar image

I have a spreadsheet with VLOOKUP, SUM and arrays to get values from one spreadsheet to another. Problem is some values shows correctly but some doesn't show or sometimes incorrect.

How can i create the behavior to consistent making all values correct. I have check all formulas and cells, seems all are correct.


edit retag flag offensive close merge delete


Please provide a test kit which shows the problem (attach the files to the edited question).

Mike Kaganski gravatar imageMike Kaganski ( 2018-08-08 06:25:04 +0200 )edit