Friday, November 23, 2012

yogi_Pull Data From Spreadsheet Standings For Position Sales And ReOrder Pulled Data By Rank In Ascending Order

                                          Google Spreadsheet   Post  #884
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 23, 2012
user batt1eship1 said: (http://productforums.google.com/forum/#!mydiscussions/docs/OxS_6fF5Flk)
Hello,
I have created two spreadsheets, one that has a ranking of names, so:
Sheet 1 (Rankings Page)
A B C
1 John AZ
2 Bill CO
3 Joe NY
Sheet 2 (Joe's page)
A B
Joe Rank 
So, i want "Rank" on Sheet 2 to pull Joe's rank of '3' from sheet one and import it into 'B' of sheet 2... so that if sheet 1 was resorted, and let's say i moved Joe to No. 2, Sheet 2 would reflect the new rank of 2 and import "2" into column "B" of sheet 2.
Hope that makes sense.
Thanks!
---
 Yogia:
Ok, I made the question a little more simple, direct and I have provided the "spreadsheet" links below, which are shared. I have also described what i want on each spreadsheet, but go to the first link and then the second. 
Thanks!

-------------------------------------------------------------------------
 following is a solution to the problem