Validate columns in other cell

[dbashyam]

Hi All,

I have a query in excel

1. I have some attribute values in excel, say

attribute
a
b
c
d


2. For 'a' the corresponding attributegroup are multiple say

attribute attributegroup
a aa
bb
cc
dd
ee
b aa
cc
dd
ff
gg
c gg
ff
dd

So, that which I choose a I should get only corresponding values for 'a' like wise if I choose 'b' I should get corresponding values for attributegroup for 'b' likewise.

Any steps that I should follow for this?

Thanks for any links or suggestions

Regards,
Dinesh

 

[Robert Mika]

Maybe this will help

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