If Condition with Multiple Search & Multiple Results
Dear Gurus,
I have a requirement where Column B contains numbers, 'W/O Ticket', 'Holiday' & 'Leave'. I need a formula in Column D, if it contains numbers, show as "Tickets", if it contains 'W/O Ticket', show as "No Tickets", and if it contains 'Holiday' show as 'Holiday' and 'Leave' as "Leave".
Currently I am using the formula as =IF(OR(B2={"W/O Ticket","Holiday","Leave"}),"NoTickets","Tickets")
Sample sheet attached herewith with expected results.
Please help.
Gem
c2=IF(ISNUMBER(B2),"Tickets",IF(B2="W/O Ticket","No Ticket",B2))
Try this and copy towards down
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
In D2 copy down
=IF(ISNUMBER(B2),"Tickets",IF(B2="W/O Ticket","No Ticket",B2))
beaten to the draw by nflsales
Last edited by kev_; 08-22-2017 at 02:13 AM.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Thanks.. Working fine...
Originally Posted by kev_
In B2 copy down
=IF(ISNUMBER(B2),"Tickets",IF(B2="W/O Ticket","No Ticket",B2))
beaten to the draw by nflsales
thanks for marking the thread as solved and for the reps
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks