put this formula into SourceBox in the Data Validation List
=OFFSET($B$1,MATCH($E$2,$A$2:$A$17,0),0,COUNTIF($A$2:$A$17,$E$2),1)
[image: Formula for List Source.PNG]
please check the attachaed workbook
best regards,
siti Vi
On Sun, Sep 19, 2010 at 2:12 PM, Deepak Rawat
wrote:
> Dear all
> I at
Dear Deepak,
Please find attachment with solution.
Thanks,
Noorain Ansari
On Sun, Sep 19, 2010 at 12:42 PM, Deepak Rawat wrote:
> Dear all
>
> I attached a sample file, the problem is
> there are two lists one is Sales_head & other is cities comes under that
> sales head
> my problem is when
Hi Deepak,
Check this Sheet.
On Sun, Sep 19, 2010 at 12:42 PM, Deepak Rawat wrote:
> Dear all
>
> I attached a sample file, the problem is
> there are two lists one is Sales_head & other is cities comes under that
> sales head
> my problem is when i select the sales head in one list then all the
Hi Deepak,
Please check this sheet. It can help you .
On Sun, Sep 19, 2010 at 12:42 PM, Deepak Rawat wrote:
> Dear all
>
> I attached a sample file, the problem is
> there are two lists one is Sales_head & other is cities comes under that
> sales head
> my problem is when i select the sales head
