Want help in multiple conditions.
Attaching excel (self explanatory)
Want help in multiple conditions.
Attaching excel (self explanatory)
Put into F4:
Formula:=IF(AND(C4=1,LEFT(D4,1)<>"P"),"Youngster",IF(AND(C4<>1,LEFT(D4,1)<>"P"),"Parent",VLOOKUP(D4,{"PLST03","Somaiya";"PLST04","ADCET";"PLST05","Xaviers"},2,0)))
and drag it down.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
try
=IF(C4=1,LOOKUP(D4,{"Normal user","PLST03","PLST04","PLST05"},{"Youngster","Somaiya","ADCET","Xaviers"}),IF(D4="Normal User","Parent",""))
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
at F4
=INDEX({"Youngster","Parent","Somaiya","ADCET","Xaviers"},MATCH(IF(C4=1,1,2)&D4,{"1NORMAL USER","2NORMAL USER","1PLST03","1PLST04","1PLST05"},0))
copy down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks