Home

Extracting data from another worksheet

%3CLINGO-SUB%20id%3D%22lingo-sub-377029%22%20slang%3D%22en-US%22%3EExtracting%20data%20from%20another%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-377029%22%20slang%3D%22en-US%22%3ESo%20I%20have%20two%20tabs%20one%20one%20is%20for%20a%20search%20criteria%20and%20the%20other%20with%20the%20raw%20data.%20I%20am%20stuck%20on%20which%20function%20to%20use%20inorder%20to%20extract%20data%20from%20the%20raw%20data%20based%20on%20multiple%20criteria.%20For%20example%20I%20am%20searching%20for%20column%20in%20the%20raw%20data%20but%20I%20only%20want%20the%20data%20if%20it%20meets%20another%20criteria%20in%20another%20column%20so%20only%20if%20it%E2%80%99s%20a%20no%20it%20column%20h%20return%20me%20what%E2%80%99s%20in%20column%20b.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-377029%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-377031%22%20slang%3D%22en-US%22%3ERe%3A%20Extracting%20data%20from%20another%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-377031%22%20slang%3D%22en-US%22%3EProvide%20a%20sample%20of%20the%20data%20you%20have%20and%20the%20result%20you%20want.%20Formulas%20are%20specific.%20Without%20the%20specifics%2C%20there%20is%20no%20formula%20to%20talk%20about.%3CBR%20%2F%3ENonetheless%2C%20I%20surmise%20you%20need%20a%20lookup%20formula%2C%20the%20choice%20of%20which%20depends%20on%20the%20specifics%20you%20provide.%3C%2FLINGO-BODY%3E
Ruby12
Occasional Visitor
So I have two tabs one one is for a search criteria and the other with the raw data. I am stuck on which function to use inorder to extract data from the raw data based on multiple criteria. For example I am searching for column in the raw data but I only want the data if it meets another criteria in another column so only if it’s a no it column h return me what’s in column b.
1 Reply
Highlighted
Provide a sample of the data you have and the result you want. Formulas are specific. Without the specifics, there is no formula to talk about.
Nonetheless, I surmise you need a lookup formula, the choice of which depends on the specifics you provide.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies