Friday, August 30, 2013

yogi_LookUp Address Of Entity In Cell B1 From A table In Another Sheet

                                          Google Spreadsheet   Post  #1350
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug 30, 2013
user Xavier Cordova question by Gheoghe: (http://productforums.google.com/forum/#!mydiscussions/docs/8TITC26rzaw)
ImportRange depending on option chosen from a dropdown list
7 posts by 4 authors
Short question:

I have a dropdownlist (names) and I would like that when I choose one name (list is in Sheet1 in column A) , the adress will show automatically in the cell bellow cell containing the dropdown (the adresses are in Sheet 1 and Column B).
And also: what if I have in column B -Street / column C- House No / Column D-Code / Column E - State or Country)

How can I get this done?
Gheorghe
---
HI,

been busy, but here we go now. Some comments for it.

I use this for invoicing some online form used by my customers. 
As you see I get the ready to print sheet ( Coaches). However I need to get the Adress under the name. The list is in Sheet called Adress See column B


Greets
G
------------------------------------------------------------------------------------------------------------