Saturday, April 27, 2013

yogi_LookUp Multiple Column Data For A Specified Entity From Another Sheet


                                          Google Spreadsheet   Post  #1159
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 27, 2013
user Xavier Marques :(https://productforums.google.com/forum/#!mydiscussions/docs/JwHwzXN4XNg)
How do I reference cell values between sheets?

Hi!

I have a sheet where every row contains a series of data relative to the same person.
(see attachment)

On sheet 2 I want to create a personal file containing all the data on the first sheet for a given person.
If I assign a value in a cell on Sheet2, for exemple B1 is 3 Is it possible to get these data using something like =Sheet1!B(Sheet2!A1) to get the name of the third person?

I want to make it so that if I want to get a personal file on any of the names, I just type their corresponding number and get sheet2 filled automatically.

Sorry if this is a bit confusing, but it's a bit hard to explain...
Attachments (2)
Screen shot 2013-04-27 at 10.49.55 PM.png
11 KB   View   Download
------------------------------------
here we go

Screen shot 2013-04-28 at 12.20.55 AM.png
5 KB   View   Download