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,
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:
following is a solution to the problem
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!
Go to this spreadsheet FIRST: https://docs.google.
Then go to this one after: https://docs.google.
-------------------------------------------------------------------------
