How to bring data in from another sheet?

Occasional Contributor

How do I bring certain matching rows from another sheet?


I need something like countif but with more power.

5 Replies

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



Best Response confirmed by kaihendry (Occasional Contributor)

@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




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