| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to use both Vlookup & data validation
Hi
I have data like Categeries, Desciption, UnitValue& UnitQty. I want to do, when i select categeries it should only show desciption of that categeries and when i select that categries it should show unitvalue & Unitqty. e.g. cat. Desc. unitValue Pens InkPen 34 boll Pen 22 Roll Pen 54 Highgrip 12 colour white 21 bule 56 Pink 66 When i select both Cat. & Desc. than only it should display unitvalue & UnitQty i try Datavalidation & Vlookup but it's not working any help. ****al |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to use both Vlookup & data validation
Take a look he
http://www.contextures.com/xlDataVal02.html HTH "****al shah" wrote: Hi I have data like Categeries, Desciption, UnitValue& UnitQty. I want to do, when i select categeries it should only show desciption of that categeries and when i select that categries it should show unitvalue & Unitqty. e.g. cat. Desc. unitValue Pens InkPen 34 boll Pen 22 Roll Pen 54 Highgrip 12 colour white 21 bule 56 Pink 66 When i select both Cat. & Desc. than only it should display unitvalue & UnitQty i try Datavalidation & Vlookup but it's not working any help. ****al |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation with hyperlinks | Excel Worksheet Functions | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
