Hi Salem, If your items have different names Excel itself has no clue what this and that item means the same. You shall help it adding unique ID for each item or other way let Excel know items in different tables means the same, even if they have different names. After that you may combine your tables to compare the prices.

Join us June 17–18 for a deep dive into Copilot Control System—live expert-led sessions and Q&A on data security, agent lifecycle, adoption, and more! Learn more >

Forum Discussion

Salem Tokhi

Copper Contributor

Nov 20, 2017

Deleted

....

Old

BI & Data Analysis

1 Reply

SergeiBaklan
MVP
Nov 20, 2017
Hi Salem,

If your items have different names Excel itself has no clue what this and that item means the same. You shall help it adding unique ID for each item or other way let Excel know items in different tables means the same, even if they have different names. After that you may combine your tables to compare the prices.