Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
need to paste link from 4 vertical cells to 4 horizontal cells? | Excel Discussion (Misc queries) | |||
Merge Cells | Excel Discussion (Misc queries) | |||
Use the Merge & Center Button with unprotected Cells - sheet prote | Setting up and Configuration of Excel | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |