want to call list name if condition padd

**Rughveda** · 12-10-2012, 07:03 AM

hello

i want to list name if condition pass.
bellow
if client name pass-it should list project listed bellow client- then its sub part
for other client other poject and its sub parts-

thanks in advance

**:) Sixthsense :)** · 12-10-2012, 07:11 AM

Not sure what is your expectation and how it should be arrived

can you please explain it briefly for better understanding.

**Rughveda** · 12-10-2012, 07:24 AM

find the attached excel.

if i select dc in client- then in project it should list dc(list created in excel)
for adani client- project list as adani
for hvar- list as hvar

-

i want to more than this when i select project name then it should list all models in project-
i had tried this one but this not work proper
=IF(E4="DC","dc",IF(E4="HVAR","hvar",IF(E4="Shintsu","Shintsu",IF(E4="adani","adani","project not found"))))

i want to use this formula to creat list(validation)

**Ace_XL** · 12-10-2012, 07:29 AM

In Data validation use
Allow -- List
Source -- =INDIRECT(E4)

**Rughveda** · 12-10-2012, 07:47 AM

how i can list models in project

**Ace_XL** · 12-10-2012, 07:53 AM

Firstly, does the above work? Does it give you desired results

how i can list models in project

In Data validation use
=INDIRECT("mod"&MATCH(E4,client,0))

**Rughveda** · 12-10-2012, 08:04 AM

thanks ACE_XL .

both are working

thanks again

want to call list name if condition padd

LinkBack

Thread Tools

Rate This Thread

Display

want to call list name if condition padd

Re: want to call list name if condition padd

Re: want to call list name if condition padd

Re: want to call list name if condition padd

Re: want to call list name if condition padd

Re: want to call list name if condition padd

Re: want to call list name if condition padd

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions