How to use both Vlookup & data validation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.

shital
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use VLookup with a range of numbers? 3
Using Vlookup to compare and validate data 1
Vlookup using if condition or any other way to slove problem 3
how to sort two equal numbers 3
How to return multiple instances using VLOOKUP 3
If statement with Vlookup - including ISNA function to compare two columns from different worksheets 4
How to group a table using VBA? 3
How to use the worksheetfunction Vlookup 7

Back
Top