LinkBack URL
About LinkBacks
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
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
Not sure what is your expectation and how it should be arrivedcan you please explain it briefly for better understanding.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
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)
In Data validation use
Allow -- List
Source -- =INDIRECT(E4)
Life's a spreadsheet, Excel!
Say thanks, Click *
how i can list models in project
Firstly, does the above work? Does it give you desired results
In Data validation usehow i can list models in project
=INDIRECT("mod"&MATCH(E4,client,0))
thanks ACE_XL .
both are working
thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks