SOLVED

How to bring data in from another sheet?

Copper 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

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

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

 

 

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

 

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

@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)

 

best response confirmed by kaihendry (Copper 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

 

 

 

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

1 best response

Accepted Solutions
best response confirmed by kaihendry (Copper 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

 

 

 

View solution in original post