SORT (Excel) doesn't work in a column created from a LOOKUP functi

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've created a column of data with each cell's content from the addition of
values in other cells.
I have another column using the LOOKUP function for data from specific cells
in the column noted above.
I want to now SORT this LOOKUP column of data in an ascending manner. The
SORT function does not do anything. WHY?
 
If your only sorting the column with the lookup function, all of the data
that it refers to is still there and you probably will get the same thing.
If you sort a larger range (including the Lookup Value), you should see it
sort.
 

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

Problem sorting a range of columns using VBA 1
lastrow function help 6
COUNTIF calculations & Two-way Lookup 2
Remove specific cells in a column. 2
Is there a better Sort than Excel's default Sort? 5
= cell above last entered data 8
VBA- Excel Programming:- 0
Sort cell values of different columns 1

Back
Top