Hi,
I have attached an excel file where I want to put a formula in cell B2 where formula will check cell A2 and if Cell A2 contains any text from list $D$2:$D$3 then formula will show the word "Commercial" otherwise it won't show anything.
If we can construct formula with if condition then I would be able to use the same formula for multiple criterias with multiple if conditions. I hope you understand the problem.
Regards,
How about
=IF(COUNT(SEARCH($D$2:$D$3,A2))>0,"Commercial","")
This may need to be confirmed with Ctrl Shift Enter
Try:Shouldn't need to make it an array formula that way.Formula:
=IF(SUMPRODUCT((A2=$D$2:$D$3)*1)>0,"Commercial","")
Sub Reputation() Dim Problem as Variant Dim Reputation as Integer For Each Problem in Forum.Threads If Problem.Title = "*[Solved]*" and Solver.Name = "Leon V (AW)" Then Reputation = Reputation + 1 Next Problem End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks