Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
return proper match from three columns
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Pete_UK, post: 6656548"] Bartt, you can find details of the Excel SEARCH function in XL Help. It is similar to FIND, but it is not case-sensitive and wildcards can be used in the find_text parameter. You could use it like this: =IF(ISNUMBER(SEARCH("FL:"&"*",IR3)),IR3,"") Hope this helps. Pete [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
return proper match from three columns
Top
