Pulling in conditional data from another tab

%3CLINGO-SUB%20id%3D%22lingo-sub-1608800%22%20slang%3D%22en-US%22%3EPulling%20in%20conditional%20data%20from%20another%20tab%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1608800%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20pull%20in%20the%20sum%20of%20data%20fitting%20a%20certain%20criteria%20from%20one%20tab%20to%20another%20and%20cannot%20get%20VLOOKUP%20or%20XLOOKUP%20to%20work%20properly.%20Please%20help.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1608913%22%20slang%3D%22en-US%22%3ERe%3A%20Pulling%20in%20conditional%20data%20from%20another%20tab%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1608913%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F769443%22%20target%3D%22_blank%22%3E%40KindalHoffman%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20share%20a%20sample%20of%20the%20data%20you%20are%20working%20with%20after%20removing%20any%20confidential%20information%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20will%20enable%20us%20to%20review%20your%20requirements%20and%20profer%20possible%20solutions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I need to pull in the sum of data fitting a certain criteria from one tab to another and cannot get VLOOKUP or XLOOKUP to work properly. Please help. 

1 Reply

@KindalHoffman 

 

Can you share a sample of the data you are working with after removing any confidential information?

 

This will enable us to review your requirements and profer possible solutions.

 

Cheers