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

https://docs.google.com/spreadsheet/ccc?key=0Ahz50a_CQ3CadEU2a1dGZGdJUzNFeEtHakFHbTA1amc&usp=sharing

Greets

G

------------------------------------------------------------------------------------------------------------