VLOOKUP SUM not getting correct values

English
,
#1

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.

Thanks

#2

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

#3

Are you set the fourth argument of VLOOKUP (SortedRangeLookup) to 0 or FALSE()?

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.