How come I can sort a table with multiple columns of vlookup and retain the
integrity of the data but I can't sort a table with multiple columns of
sumproduct while retaining the integrity of the data.

Any ideas?

Thanks!

I've seen your formula in your other posting (but others may not have
done - why not include the more detailed description here?) Are you
sorting the "Discounted" sheet? I'm a little confused, even after your
fuller explanation in the other post.

Pete

On Aug 20, 11:40 pm, Lauren wrote:
How come I can sort a table with multiple columns of vlookup and retain the
integrity of the data but I can't sort a table with multiple columns of
sumproduct while retaining the integrity of the data.

Any ideas?

Thanks!