• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

multiple if statement

S

slohman

Member
Can some help me?

I need to write a formula that will find the text Travis in M45 and put a phone number 039123456 in M47 but if the test Andrew is found in M45 I need M47 to read 987654612 or if the text Peter is found in M45 then M47 is to read 0397846124
 
Hi Slohman,


For the second part like if the test Andrew is found in M45 I need M47 to read 987654612 or if the text Peter is found in M45 then M47 is to read 0397846124


Try the below forumla on Range M47


=IF(M45="Andrew",987654612,IF(M45="Peter",397846124," "))


Thanks,

Suresh Kumar S
 
Slohman,

write the formula in M47

=IF(M45="Travis","039123456",IF(M45="Andrew","987654612",IF(M45="Peter","397846124","")))


Regards,

--Muneer
 
Hi Slohman,


Can you try the below formula in M47.


=IF(M45="Andrew",987654612,IF(M45="Peter",397846124,IF(MID(M45,SEARCH("Tra",M45)+0,6)="Travis",39123456)))


Thanks,

Suresh Kumar S
 
Another one..


=LOOKUP(M45,{"Andrew","987654612";"Peter","397846124";"Travis","039123456"})


Names must be in ascending order


or


=INDEX({"039123456","987654612","397846124"},MATCH(M45,{"Travis","Andrew","Peter"},0))


Kris
 
You must log in or register to reply here.
Back
Top