SOLVED

How to bring data in from another sheet?

%3CLINGO-SUB%20id%3D%22lingo-sub-1505089%22%20slang%3D%22en-US%22%3EHow%20to%20bring%20data%20in%20from%20another%20sheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1505089%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20bring%20certain%20matching%20rows%20from%20another%20sheet%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20something%20like%20countif%20but%20with%20more%20power.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fs.natalian.org%2F2020-07-06%2Fbring-in-data.mp4%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fs.natalian.org%2F2020-07-06%2Fbring-in-data.mp4%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1505089%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor

How do I bring certain matching rows from another sheet?

 

I need something like countif but with more power.

 

https://s.natalian.org/2020-07-06/bring-in-data.mp4

5 Replies
Highlighted

@kaihendry Perhaps like in the attached example workbook, using VLOOKUP?

=VLOOKUP([@Machine],Table2,2,0)

 

 

Highlighted

Instead of the index "2", could I used a named column or the header?

 

https://s.natalian.org/2020-07-06/not-index.mp4

Highlighted

@kaihendry You can add a MATCH function to find the matching column name in the 2nd table. For example:

=VLOOKUP([@Machine],Table2,MATCH(Table1[[#Headers],[Attribute]],Table2[#Headers],0),0)

 

Highlighted
Best Response confirmed by kaihendry (Occasional Contributor)
Solution

@Riny_van_Eekelen I'm getting #N/A with that formula.

 

Does strike me as quite painful of joining tables this way. Surely there is an easier method?

 

UPDATE: Ok, I figured it out with Power Query https://s.natalian.org/2020-07-07/combine.mp4

 

 

 

Highlighted

@kaihendry Indeed! That's also a way to merge tables.