Home

Transfering Text from one sheet to another using multiple criteria

%3CLINGO-SUB%20id%3D%22lingo-sub-622682%22%20slang%3D%22en-US%22%3ETransfering%20Text%20from%20one%20sheet%20to%20another%20using%20multiple%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-622682%22%20slang%3D%22en-US%22%3E%3CP%3EHelp%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20looking%20to%20transfer%20numerous%20text%20infomation%20from%20one%20sheet%20to%20another%20using%20Period%20number%20and%20matching%20other%20if%20formation.%20If%20i%20was%20looking%20to%20complete%20it%20for%20figures%20it%20would%20look%20something%20like%20this%26nbsp%3B%3DSUMIFS(Info!M%3AM%2CInfo!A%3AA%2CA5%2CInfo!D%3AD%2CA7)%20but%20for%20text%20how%20do%20i%20do%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-622682%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-623168%22%20slang%3D%22en-US%22%3ERe%3A%20Transfering%20Text%20from%20one%20sheet%20to%20another%20using%20multiple%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-623168%22%20slang%3D%22en-US%22%3EFor%20better%20appreciation%20of%20the%20outputs%20you%20want%2C%20based%20on%20given%20inputs%2C%20I%20recommend%20you%20attach%20your%20sample%20file.%3C%2FLINGO-BODY%3E
mossphillip81
Occasional Visitor

Help 

 

I am looking to transfer numerous text infomation from one sheet to another using Period number and matching other if formation. If i was looking to complete it for figures it would look something like this =SUMIFS(Info!M:M,Info!A:A,A5,Info!D:D,A7) but for text how do i do this?

 

Thanks

1 Reply
For better appreciation of the outputs you want, based on given inputs, I recommend you attach your sample file.
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies