Hi Bruno,
Thanks a ton for helping me.
Thanks
Kalyan
On Tue, Aug 31, 2010 at 3:41 AM, Bruno Bruno wrote:
> Hi Maries,
>
> This formula might look complicated, but it's actually simple if we "break"
> it into pieces.
> But before doing it, we first need to understand the idea: we want to,
> ba
Hi Maries,
This formula might look complicated, but it's actually simple if we "break"
it into pieces.
But before doing it, we first need to understand the idea: we want to, based
on the value of cell B7, return the corresponding range of possible values
that are on another sheet.
So, for example:
Hi! Bruno,
Can you explain me the logic which you used second data validation
=INDIRECT("'PRD Range'!" & LEFT(ADDRESS(1,MATCH('Dropdown
List'!$B$7,Brand,0),2),1+(MATCH('Dropdown
List'!$B$7,Brand,0)>26))&"2:"&LEFT(ADDRESS(1,MATCH('Dropdown
List'!$B$7,Brand,0),2),1+(MATCH('Dropdown
List'!$B$7,Brand
On Mon, Aug 30, 2010 at 2:03 PM, adel elshafe wrote:
> its a usful link
>
> http://helpdeskgeek.com/office-tips/create-multiple-linked-dropdown-lists-in-excel/
>
>
>
> On Mon, Aug 30, 2010 at 12:04 PM, Kal xcel wrote:
>
>> Dear Experts,
>>
>> I need a help to create multiple linked dropdown lists
its a usful link
http://helpdeskgeek.com/office-tips/create-multiple-linked-dropdown-lists-in-excel/
On Mon, Aug 30, 2010 at 12:04 PM, Kal xcel wrote:
> Dear Experts,
>
> I need a help to create multiple linked dropdown lists. Please go through
> the attached file, details is there.
>
> Thanks