Hello,
First of all, please bear with me if I am explaining what I need unclearly. I'm working with Office365
1. In Sheet1, Column M, I need the information to pull from the Raw Tab Column K. It should be the sum of what it is based on the EOB Batch #. This will require a combination of SUMIF (or SUMIFS) with XLOOKUP.
2. In Sheet1, Column O, if there is a discrepancy in Column N, I need to tell me how much of a discrepancy there is based on Raw's Column K.
3. In Sheet1, Column P, to tell me the culprit of the discrepancy from Raw's Column D.
Again, if it needs further clarification please let me know.
My current attempt for Column M is =XLOOKUP(b3,'Raw'!A:A,XLOOKUP(f3,'Raw'!D:D,'Raw'!K:K))
Bookmarks