Sorting VLookup vs Sorting SumProduct
 

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!

Sorting VLookup vs Sorting SumProduct
 

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!