|
|
#4
05-30-2017, 07:03 AM
|
||||
|
||||
If your turn the ID entries in both sheets into text entries, so that 1.1 is not the same as 1.10 (when entered as number), then you can use formula in N2:
=INDEX(Evaluation!Q:Q,MATCH(B2,Evaluation!A:A,0)) copied down and in O2 =INDEX(Evaluation!P:P,MATCH(B2,Evaluation!A:A,0)) copied down. Then you will be able to sort by those 2 columns. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 help with formulas
|
ferrarifx | Excel | 2 | 11-16-2016 12:04 PM |
| Using Right and Len formulas together | PDGood | Excel | 4 | 11-20-2015 06:50 AM |
| Need help with formulas please | paul_pearson | Excel | 0 | 03-20-2013 06:51 AM |
|
Doing a linked paste within a linked spreadsheet
|
tkondaks | Word | 1 | 08-17-2012 12:23 AM |
|
IF Formulas
|
mizzamzz | Excel | 1 | 07-08-2010 02:32 AM |
Windows 7 64bit 
Office 2007
Threaded Mode