Sorting VLookup vs Sorting SumProduct

L

Lauren

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

Cannot sort a table containing text 5
Phone notification 0
Vlookup with alphanumeric values 4
Internal Data Integrity (Type 4) Details Needed 1
Sorting multiple columns that have similar data 0
Changing row background from external program 0
Access 2010 DB not fuctional with multiple users 2
Sort data with blank rows dividing data 5

Top