How to combine tables side by side in excel
In this video I show you three ways of merging two tables together in excel. Using VLOOKUP, INDEX & MATCH and Power Query.
=IFNA(VLOOKUP($A2,$Q$2:$V$9,I$1,FALSE),"")
=IFNA(INDEX($Q$2:$V$9,MATCH($A2,$Q$2:$Q$9,0),I$1),"")
Query is only included in Excel 2016. In Excel 2010 and Excel 2013 it is an add-in called power query. Watch this other video for more information. • Excel 2013 Power Query #01: Append 3 ...
---------------------------------------------------------------------------------
#exceltutorials #excelformulas #excelpowerquery
SUBSCRIBE: https://goo.gl/c46YPs
VIDEO INFO: These data are related to my PhD research.
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
'How to combine tables with different columns in excel' • How to combine tables with different ...
'How to combine tables one on top of the other in excel' • How to combine tables one on top of t...
'Compare lists to find missing values in excel' • Compare lists to find missing values ...