Relating cells
 

I have a data base on Excel and an additional sheet on the same file where
the people of the company will fill in some cells with different info.
I need to know how, if I have three related cells, people just need to type
in the first one to get just those results related to the cell typed. I mean,
if I have State, Zip Code and Neighborhood I may select the State and I will
get just the Zip Codes that refer to that State, the same would happen with
the Neighborhood where it would appear just the one related to that specific
Zip Code. How could I get this done?

Relating cells
 

Sounds like you want dependent Data Validation lists - this link will
show you how to set this up:

http://www.contextures.com/xlDataVal02.html

Hope this helps.

Pete

PaulinaDi wrote:
I have a data base on Excel and an additional sheet on the same file where
the people of the company will fill in some cells with different info.
I need to know how, if I have three related cells, people just need to type
in the first one to get just those results related to the cell typed. I mean,
if I have State, Zip Code and Neighborhood I may select the State and I will
get just the Zip Codes that refer to that State, the same would happen with
the Neighborhood where it would appear just the one related to that specific
Zip Code. How could I get this done?

Relating cells
 

WOW! This page really works. It was a little hard to understand some issues
but I have my columns related. Should I do the same for a third column? I
mean, the column referring to the neighborhood

"Pete_UK" wrote:

Sounds like you want dependent Data Validation lists - this link will
show you how to set this up:

http://www.contextures.com/xlDataVal02.html

Hope this helps.

Pete

PaulinaDi wrote:
I have a data base on Excel and an additional sheet on the same file where
the people of the company will fill in some cells with different info.
I need to know how, if I have three related cells, people just need to type
in the first one to get just those results related to the cell typed. I mean,
if I have State, Zip Code and Neighborhood I may select the State and I will
get just the Zip Codes that refer to that State, the same would happen with
the Neighborhood where it would appear just the one related to that specific
Zip Code. How could I get this done?

Relating cells
 

Try INDEX/MATCH Functions


"PaulinaDi" wrote:

I have a data base on Excel and an additional sheet on the same file where
the people of the company will fill in some cells with different info.
I need to know how, if I have three related cells, people just need to type
in the first one to get just those results related to the cell typed. I mean,
if I have State, Zip Code and Neighborhood I may select the State and I will
get just the Zip Codes that refer to that State, the same would happen with
the Neighborhood where it would appear just the one related to that specific
Zip Code. How could I get this done?