| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Please help...how to create a spreadsheet with these criteria?
Hi,
I need to setup a spreadsheet that has criteria go like this: Cell A3 - Enter a key word. It will give me a list of the searched key words (maybe comes from Data Validation List formula) for selection. Cell B3 - It may shows two or more cells information for selection, after cell A3 information select. The selection can come in drop-down list, or appears in column B cells. Cell C3 - It may shows two or more cells information for selection, after cell B3 information select. The selection can come in drop-down list, or appears in column C cells. I know I need to use VLookUp and other formulas. But how should I go about setting up this spreadsheet criteria? -- Thank you, Cpviv |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Please help...how to create a spreadsheet with these criteria?
hi
not sure but i think you may be talking about dependent list or sometimes called cascading combos See this site..... http://www.contextures.com/xlDataVal02.html regards FSt1 "Cpviv" wrote: Hi, I need to setup a spreadsheet that has criteria go like this: Cell A3 - Enter a key word. It will give me a list of the searched key words (maybe comes from Data Validation List formula) for selection. Cell B3 - It may shows two or more cells information for selection, after cell A3 information select. The selection can come in drop-down list, or appears in column B cells. Cell C3 - It may shows two or more cells information for selection, after cell B3 information select. The selection can come in drop-down list, or appears in column C cells. I know I need to use VLookUp and other formulas. But how should I go about setting up this spreadsheet criteria? -- Thank you, Cpviv |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create list from criteria | Excel Discussion (Misc queries) | |||
| Look up from spreadsheet based on 6 criteria | Excel Discussion (Misc queries) | |||
| Create a chart depending on different criteria | Charts and Charting in Excel | |||
| How do I create criteria blocks | Excel Discussion (Misc queries) | |||
| How do I create a COUNTIF function with more than one criteria? | Excel Worksheet Functions | |||
Linear Mode
