LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 15
Default Using the wildcard with IF

Hi all,
I'm trying to set up a message that will generate from an IF formula. At the
moment I'm at:

=IF(E3="*C3","","Please check that you have chosen")

The content of C3 is a part of the content in E3 e.g. E3=161426 oxygen and
C3=oxygen. I want to check that what is in C3 is also in E3 and, if not, put
up a message. All help appreciated.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If and wildcard Fish Excel Discussion (Misc queries) 3 October 1st 08 01:33 AM
wildcard characters Hasty Excel Discussion (Misc queries) 2 July 21st 06 10:40 AM
sum if wildcard Marcel New Users to Excel 1 April 30th 06 11:25 AM
Wildcard string Robo Excel Discussion (Misc queries) 2 November 22nd 05 03:26 PM
wildcard in sumproduct? cjjoo Excel Worksheet Functions 2 October 17th 05 01:08 PM


All times are GMT +1. The time now is 02:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"