I am trying to use List in excel. My main goal is to get a list to populate
more than one cell. I want it to populate the "name" "DOB" "SSAN" and
"Gender" from one list rather than trying to match the name DOB SSAN and
gender to each other from seperate list. Anyone know how to do this?

A1c Woods, Marcus E

Perhaps you want to try your question again. I can't speak for everyone, but
to me, it isn't clear what you have, what you want, or what you are trying to
do.

the term list is ambiguous in the programming newsgroup. Do you mean the
ListObject introduced in xl2003, are you refering to the list property of a
listbox or combobox, or are you using the term list generically to describe a
series of related cells set up like a database. What do you mean by
populate. Populate is an action - cells don't populate themselves.

--
Regards,
Tom Ogilvy


"Marcus Woods" wrote:

I am trying to use List in excel. My main goal is to get a list to populate
more than one cell. I want it to populate the "name" "DOB" "SSAN" and
"Gender" from one list rather than trying to match the name DOB SSAN and
gender to each other from seperate list. Anyone know how to do this?

A1c Woods, Marcus E

Thanks Tom,

I am new to microsoft products since I never used them before I joined the
air force, unless I was writing a term paper and I used word on a school
computer.

To clerify. Right now I have two worksheets. It is a roster that will be
filled when needed and must be filled quickly and accurately ON DEMAND. The
first worksheet has static information that will always be there. The second
worksheet has list that can change but not often. Mostly Names Ranks and
Socials etc.

I want to match the names ranks and socials to specific criteria in the main
worksheet.

Name SSN Rank JT Position

those are some of the criteria in the main worksheet. the JT or "Joint
Team" and Position are static items while the name social and rank would be
the person who fills the position.

Right now I have a "list" created through the Data Validation menu that
will fill just the name. I want it to also fill the SSN, Rank, etc. criteria
as well.

Does this help any?

"Tom Ogilvy" wrote:

Perhaps you want to try your question again. I can't speak for everyone, but
to me, it isn't clear what you have, what you want, or what you are trying to
do.

the term list is ambiguous in the programming newsgroup. Do you mean the
ListObject introduced in xl2003, are you refering to the list property of a
listbox or combobox, or are you using the term list generically to describe a
series of related cells set up like a database. What do you mean by
populate. Populate is an action - cells don't populate themselves.

--
Regards,
Tom Ogilvy


"Marcus Woods" wrote:

I am trying to use List in excel. My main goal is to get a list to populate
more than one cell. I want it to populate the "name" "DOB" "SSAN" and
"Gender" from one list rather than trying to match the name DOB SSAN and
gender to each other from seperate list. Anyone know how to do this?

A1c Woods, Marcus E

Use the vlookup function

=if(dropdowncell = "","",vlookup(dropdowncell,statictable,2,False ))

would return the SSN for the name entered in the cell with the dropdown. If
no entry were in the dropdown cell, it would appear blank. the 2 represents
the column in the "statictable"/Main range from which the value will be
returned. If you wanted Rank, you would use 3.

--
Regards,
Tom Ogilvy


"Marcus Woods" wrote:

Thanks Tom,

I am new to microsoft products since I never used them before I joined the
air force, unless I was writing a term paper and I used word on a school
computer.

To clerify. Right now I have two worksheets. It is a roster that will be
filled when needed and must be filled quickly and accurately ON DEMAND. The
first worksheet has static information that will always be there. The second
worksheet has list that can change but not often. Mostly Names Ranks and
Socials etc.

I want to match the names ranks and socials to specific criteria in the main
worksheet.

Name SSN Rank JT Position

those are some of the criteria in the main worksheet. the JT or "Joint
Team" and Position are static items while the name social and rank would be
the person who fills the position.

Right now I have a "list" created through the Data Validation menu that
will fill just the name. I want it to also fill the SSN, Rank, etc. criteria
as well.

Does this help any?

"Tom Ogilvy" wrote:

Perhaps you want to try your question again. I can't speak for everyone, but
to me, it isn't clear what you have, what you want, or what you are trying to
do.

the term list is ambiguous in the programming newsgroup. Do you mean the
ListObject introduced in xl2003, are you refering to the list property of a
listbox or combobox, or are you using the term list generically to describe a
series of related cells set up like a database. What do you mean by
populate. Populate is an action - cells don't populate themselves.

--
Regards,
Tom Ogilvy


"Marcus Woods" wrote:

I am trying to use List in excel. My main goal is to get a list to populate
more than one cell. I want it to populate the "name" "DOB" "SSAN" and
"Gender" from one list rather than trying to match the name DOB SSAN and
gender to each other from seperate list. Anyone know how to do this?

A1c Woods, Marcus E

How do i reference the dropdowncell and what does statictable referencing.

"Tom Ogilvy" wrote:

Use the vlookup function

=if(dropdowncell = "","",vlookup(dropdowncell,statictable,2,False ))

would return the SSN for the name entered in the cell with the dropdown. If
no entry were in the dropdown cell, it would appear blank. the 2 represents
the column in the "statictable"/Main range from which the value will be
returned. If you wanted Rank, you would use 3.

--
Regards,
Tom Ogilvy


"Marcus Woods" wrote:

Thanks Tom,

I am new to microsoft products since I never used them before I joined the
air force, unless I was writing a term paper and I used word on a school
computer.

To clerify. Right now I have two worksheets. It is a roster that will be
filled when needed and must be filled quickly and accurately ON DEMAND. The
first worksheet has static information that will always be there. The second
worksheet has list that can change but not often. Mostly Names Ranks and
Socials etc.

I want to match the names ranks and socials to specific criteria in the main
worksheet.

Name SSN Rank JT Position

those are some of the criteria in the main worksheet. the JT or "Joint
Team" and Position are static items while the name social and rank would be
the person who fills the position.

Right now I have a "list" created through the Data Validation menu that
will fill just the name. I want it to also fill the SSN, Rank, etc. criteria
as well.

Does this help any?

"Tom Ogilvy" wrote:

Perhaps you want to try your question again. I can't speak for everyone, but
to me, it isn't clear what you have, what you want, or what you are trying to
do.

the term list is ambiguous in the programming newsgroup. Do you mean the
ListObject introduced in xl2003, are you refering to the list property of a
listbox or combobox, or are you using the term list generically to describe a
series of related cells set up like a database. What do you mean by
populate. Populate is an action - cells don't populate themselves.

--
Regards,
Tom Ogilvy


"Marcus Woods" wrote:

I am trying to use List in excel. My main goal is to get a list to populate
more than one cell. I want it to populate the "name" "DOB" "SSAN" and
"Gender" from one list rather than trying to match the name DOB SSAN and
gender to each other from seperate list. Anyone know how to do this?

A1c Woods, Marcus E

Tom is it possible I can send you a copy of the worksheet I am working on so
that you can better help me?

Marcus

"Tom Ogilvy" wrote:

Use the vlookup function

=if(dropdowncell = "","",vlookup(dropdowncell,statictable,2,False ))

would return the SSN for the name entered in the cell with the dropdown. If
no entry were in the dropdown cell, it would appear blank. the 2 represents
the column in the "statictable"/Main range from which the value will be
returned. If you wanted Rank, you would use 3.

--
Regards,
Tom Ogilvy


"Marcus Woods" wrote:

Thanks Tom,

I am new to microsoft products since I never used them before I joined the
air force, unless I was writing a term paper and I used word on a school
computer.

To clerify. Right now I have two worksheets. It is a roster that will be
filled when needed and must be filled quickly and accurately ON DEMAND. The
first worksheet has static information that will always be there. The second
worksheet has list that can change but not often. Mostly Names Ranks and
Socials etc.

I want to match the names ranks and socials to specific criteria in the main
worksheet.

Name SSN Rank JT Position

those are some of the criteria in the main worksheet. the JT or "Joint
Team" and Position are static items while the name social and rank would be
the person who fills the position.

Right now I have a "list" created through the Data Validation menu that
will fill just the name. I want it to also fill the SSN, Rank, etc. criteria
as well.

Does this help any?

"Tom Ogilvy" wrote:

Perhaps you want to try your question again. I can't speak for everyone, but
to me, it isn't clear what you have, what you want, or what you are trying to
do.

the term list is ambiguous in the programming newsgroup. Do you mean the
ListObject introduced in xl2003, are you refering to the list property of a
listbox or combobox, or are you using the term list generically to describe a
series of related cells set up like a database. What do you mean by
populate. Populate is an action - cells don't populate themselves.

--
Regards,
Tom Ogilvy


"Marcus Woods" wrote:

I am trying to use List in excel. My main goal is to get a list to populate
more than one cell. I want it to populate the "name" "DOB" "SSAN" and
"Gender" from one list rather than trying to match the name DOB SSAN and
gender to each other from seperate list. Anyone know how to do this?

A1c Woods, Marcus E