Hello,
Trust every1 is doin grt?
Please i've got a scenario where i want to input text in one cell and based on the text a 'pop up' appears in another cell.
http://www.excelforum.com/excel-gene...ell-value.html
The above link sort of addresses my problem and i have used it
=IF(AND(ISTEXT(O28),(O28)="red"),"Your message here","")
my problem is that i want this message to also appear if "orange" is typed.
Is this possible?
Thanks in anticipation
try
=IF(AND(ISTEXT(O28),OR(O28={"red","orange"})),"Your message here","")
Last edited by shukla.ankur281190; 01-21-2016 at 06:12 AM.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Try:
Formula:
Please Login or Register to view this content.
Best Regards,
Kaper
If you want 2 messages
=IF(O28="RED","Your Message 1",IF(O28="Orange","Message 2"," "))
It will return Red or Orange or just leave a blank cell
Last edited by BlindAlley; 01-21-2016 at 06:21 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks