Thread: If statement to compare for wildcard value in another cell.
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karen53 Karen53 is offline
external usenet poster
  
Posts: 333
Default If statement to compare for wildcard value in another cell.
thanks Biff.

the data is text and what I'm testing for could have text before it and
after it. I used your suggestion but tried substituting ISTEXT but it did
not work. The statement should have been true and returned 1 but it returns
0.
Reply With QuoteReply With Quote