View Single Post
 
Old 05-30-2017, 07:03 AM
NBVC's Avatar
NBVC NBVC is offline Windows 7 64bit Office 2007
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

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.
Reply With Quote