Merging two different spreadsheets with a single common denominator using Power Query

[TexasHeat]

So I have two different spreadsheets. Both give totally different information, but they both can have the same common denominator that is the "Vehicle #". I'm trying to merge the two documents based on that, but I can't get the information to appear correctly when using Power Query. When appending the two documents, the primary document information all appears there, but the table to append to the primary tables doesn't have the column details included. They just appear as "null". The column titles are there, but not the details. In addition, I don't think they are linking up to the same "Vehicle #" in order to sync the data.

I'm not sure if Power Query is the right mechanism for what I'm doing, and if it is I'm not sure what I'm doing wrong. Any help would be greatly apprciated.

 

[ImkeF]

This sounds as if the merge-Operation would be more suitable here (you find it above/beneath the append-button). Join on "Vehicle #".

 

[shawnhet]

Hi there,

Welcome to the board!

I've never used Power Query so I'm not sure if it would be faster but either the VLOOKUP or INDX MATCH formulae should work depending on the format of your second table.

If you post some samples of your data, I can give you more details.

Cheers,

 

[TexasHeat]

I don't see where I am able to attach the files with information. I know it's on here somewhere, but I don't see it.

 

[ImkeF]

Have a look here: https://support.office.com/en-nz/ar...c0f-b132-7ca2616d17f9?ui=en-US&rs=en-NZ&ad=NZ

 

[TexasHeat]

I'm going to just try to dumb it down a bit, and use Pivot Tables to get precise information instead of trying to do it all at once. I think it will serve me better. Especially since I'm spending so much time try to troubleshoot.