Forum Discussion
VLOOKUP based off different tables
- Anonymous5 years ago
Hi deaddingo ,
As long as they have the same column names, they can be appended successfully.
If the column names are different, let me give you an example. If I renamed the Status in the ROD table to Status 1, the following effects will appear.
Then right-click the column name to sort, the results are as follows
You just select append query as new. If it is not right, just delete the newly appeared table.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Why don't you 'Append Queries' on the 3 tables (in Power Query) and throw away the Excel summary table?
Unfortunately the 3 tables don't all have the same columns in them. The examples were just a very simplified version so I cant append unfortunately.