Been doing some work with one of my spreadsheets and have 2 columns, both with VLOOKUP results in from different views. I can’t do any maths on the results it seems.
C5 = VLOOKUP(A5,'RAW1'!$A$2:$V$346,22,FALSE)*1000 = £ 35269000 D5 = VLOOKUP(A5,'RAW2'!$A$2:$O$427,15,FALSE) = 93,663 E5 = C5/D5 = #VALUE
Not sure this is intended behaviour!
P.S. Is a ‘thousands separator’ in the works at all? Would be nice to make things more readable. In the example above, this is the formatting of the data I copied over… Be good to be able to change it in DashDash
Hope this helps!