Should be an easy one for you Gurus...

[Jennifer Carr]

Okay,
I'm making a Sales quotation sheet:
In it I have a database of customer addresses in columns like this:
Column A Column B Column C...
Company Address City State Zip So on...

I want to be able to select a company in one cell (I've already created a
list in Data Validation) and have the address, city, state, etc come up
below like this:

Company Name (select this cell)
Address
City, St Zip
Phone
Fax

So in sum:
Select one cell, the cells below fill in automatically the address info
from the database columns.
Make sense?
Thanks everyone!!!

[Dave Peterson]

If the company names are unique, it looks like you could use =vlookup() to
return those other values:

=if(a1="","",vlookup(a1,sheet2!A:G,2,false))
and
=if(a1="","",vlookup(a1,sheet2!A:G,3,false))
and so forth.

and maybe:
=if(a1="","",vlookup(a1,sheet2!A:G,3,false) & ", "
& vlookup(a1,sheet2!A:G,4,false) & " "
& vlookup(a1,sheet2!A:G,5,false))

(remember to change the lookup range (I used A:G) to match your needs.)


Visit Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html
for nice instructions.



Jennifer Carr wrote:
>
> Okay,
> I'm making a Sales quotation sheet:
> In it I have a database of customer addresses in columns like this:
> Column A Column B Column C...
> Company Address City State Zip So on...
>
> I want to be able to select a company in one cell (I've already created a
> list in Data Validation) and have the address, city, state, etc come up
> below like this:
>
> Company Name (select this cell)
> Address
> City, St Zip
> Phone
> Fax
>
> So in sum:
> Select one cell, the cells below fill in automatically the address info
> from the database columns.
> Make sense?
> Thanks everyone!!!

--

Dave Peterson

[Mangus Pyke]

>Jennifer Carr wrote:

I knew a Jennifer Carr in college.. at Dickinson

MP-
--
"Learning is a behavior that results from consequences."
B.F. Skinner

[Jennifer Carr]

Thanks! That did it!

On 7/27/05 9:29 PM, in article [email protected], "Dave
Peterson" <[email protected]> wrote:

> If the company names are unique, it looks like you could use =vlookup() to
> return those other values:
>
> =if(a1="","",vlookup(a1,sheet2!A:G,2,false))
> and
> =if(a1="","",vlookup(a1,sheet2!A:G,3,false))
> and so forth.
>
> and maybe:
> =if(a1="","",vlookup(a1,sheet2!A:G,3,false) & ", "
> & vlookup(a1,sheet2!A:G,4,false) & " "
> & vlookup(a1,sheet2!A:G,5,false))
>
> (remember to change the lookup range (I used A:G) to match your needs.)
>
>
> Visit Debra Dalgleish's site:
> http://www.contextures.com/xlFunctions02.html
> for nice instructions.
>
>
>
> Jennifer Carr wrote:
>>
>> Okay,
>> I'm making a Sales quotation sheet:
>> In it I have a database of customer addresses in columns like this:
>> Column A Column B Column C...
>> Company Address City State Zip So on...
>>
>> I want to be able to select a company in one cell (I've already created a
>> list in Data Validation) and have the address, city, state, etc come up
>> below like this:
>>
>> Company Name (select this cell)
>> Address
>> City, St Zip
>> Phone
>> Fax
>>
>> So in sum:
>> Select one cell, the cells below fill in automatically the address info
>> from the database columns.
>> Make sense?
>> Thanks everyone!!!