Hello,
In a summing worksheet I'm using the vlookup function to find matches of data in other worksheets.
In one of the columns for some reason the data isn't correct and I don't manage to figure out what
causes this error. If anyone could help to find the problem I will be glad.
I have attached the file. The problematic column is I (scanner), in the "Sum parts" worksheet.
Thanks, Amitai
can you tell me in which cell it is showing wrong result
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Can't see the problem:
The total of [SUM parts] column I = 60.
The total of [Scanner] column B = 60.
So your total quantities match.
Where do you think you're seeing an error?
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
I have found the mistake which was having the same
data appearing twice in the same column, and therefor
calculated once instead of twice.
Sorry for the bother.
Amitai
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks