Hi

We have two tables which we are trying to merge.

The left one defines top 20 suppliers with their market share in cur month, previous month, cur ytd, current ytd.

The right one gives us the sales change % between cur and previous month and between current and previous ytd.

We would like to add the two columns from the right table to the left one, in a way that vlookup would deal with it in excel.

The reason that we could not combine them in the original discovery is that change % calculation would calculate the % change in market share in this way, but not the sales.

Any ideas?

Many thanks