Hi,
I have a working formula
Please Login or Register to view this content.
Now the formula works when a cell in column OC in worksheet OfferDetails (which is what the named range Offerinoc refers to) has just one value - example - 685-cf-18A .
So if rngOC = 685-cf-18A , the formula works.
If it has say, three , 685-cf-18A ,685-cf-24b, 685-cf-11c then it doesn't work.
I need to be able to match one of these three to rngOC.
by replacing Offerinoc=rngOC with (IF(COUNTIF(Offerinoc, "*"&rngOC&"*")>0,rngOC)=rngOCPlease Login or Register to view this content.
Also tried
but the cell remains blank.Please Login or Register to view this content.
I dont know if i am using the wrong function -countif ?
What could be the error. Would very much be grateful for help !
thanks.
anandi
Bookmarks