Jul 06 2020 02:18 AM
How do I bring certain matching rows from another sheet?
I need something like countif but with more power.
Jul 06 2020 02:34 AM
@kaihendry Perhaps like in the attached example workbook, using VLOOKUP?
=VLOOKUP([@Machine],Table2,2,0)
Jul 06 2020 03:06 AM
Instead of the index "2", could I used a named column or the header?
Jul 06 2020 03:17 AM
@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)
Jul 06 2020 05:13 PM - edited Jul 06 2020 07:30 PM
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
Jul 07 2020 01:55 AM
@kaihendry Indeed! That's also a way to merge tables.
Jul 06 2020 05:13 PM - edited Jul 06 2020 07:30 PM
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