How do I bring certain matching rows from another sheet?
I need something like countif but with more power.
View best response
@kaihendry Perhaps like in the attached example workbook, using VLOOKUP?
Instead of the index "2", could I used a named column or the header?
@kaihendry You can add a MATCH function to find the matching column name in the 2nd table. For example:
@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.