Sorting VLookup vs Sorting SumProduct

G

Guest

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!
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting multiple columns and maintaining grouping of information 2
stop sorting titles please 3
VLookup VS SumProduct 5
sorting with blank dates 3
Vlookup and sorting 3
Sorting multiple columns (fields) in a pivot table 1
How do I keep my row formatting when sorting data? 1
Insert empty columns in list w/o header 2

Top