Difference between FIND function and SEARCH function

preview_player
Показать описание
Do you want to know the difference between the Find function and the Search function in Microsoft® Excel 2013? This video will show you the difference between FIND function and SEARCH function in Microsoft® Excel 2013.

Content in this video is provided on an "as is" basis with no express or implied warranties whatsoever. Any reference of any third party logos, brand names, trademarks, services marks, trade names, trade dress and copyrights shall not imply any affiliation to such third parties, unless expressly specified.
  1. How-To Guide
  2. Microsoft Excel (Software)
  3. Microsoft Corporation (Venture Funded Company)
  4. Software (Industry)
  5. SEARCH function
  6. FIND function
Рекомендации по теме
Find and Search 0:09:48

Find and Search Functions |Difference between find and Search in Excel

Difference in Find() 0:03:40

Difference in Find() and Search() Functions in Excel

How to Find 0:05:58

How to Find the Difference of Functions | Algebra, Subtracting Functions, Differences of Functions

How to find 0:01:08

How to find the difference of two functions

Difference Between Partial 0:01:44

Difference Between Partial and Total Derivative

Algebra Ch 43: 0:02:48

Algebra Ch 43: Functions and Relations (1 of 11) What is Difference Between Relations and Functions?

.equals() vs. == 0:08:48

.equals() vs. == in Java - The Real Difference

Difference between equations 0:04:18

Difference between equations and functions | Functions and their graphs | Algebra II | Khan Academy

Differences between __repr__ 0:10:55

Differences between __repr__ vs __str__ in Python

What's the Difference 0:03:41

What's the Difference Between Expressions and Equations?

Spot The Difference 0:09:17

Spot The Difference : Only Genius Find Differences [ Find The Difference #84 ]

Excel: Difference of 0:01:35

Excel: Difference of two columns

What Is The 0:09:37

What Is The Difference Between Filter And Find Method || Find And Filter Method Difference || Es6

Difference between dot 0:06:18

Difference between dot and text() function in Xpath in Selenium | Locate WebElement using dot (.)

SQL 'difference between' 0:08:20

SQL 'difference between' interview questions (part 1)

How to tell 0:04:49

How to tell the difference between onto and one to one functions

Maximum difference between 0:13:54

Maximum difference between two elements in an Array

Find the difference 0:04:38

Find the difference between 2 polynomials by rewriting as addition problem by distributing

diff Function in 0:03:27

diff Function in R (2 Examples) | How to Calculate the Difference with & without Lag

Replace and Substitute 0:10:54

Replace and Substitute Functions | Difference between Replace and Substitute in Excel | in Hindi

Codomain and Range 0:01:35

Codomain and Range of a Function Difference

How to Find 0:03:23

How to Find the Difference Between Two Numbers

What is the 0:01:47

What is the difference between Motif and domain of a protein?

Python Quick Tip: 0:08:51

Python Quick Tip: The Difference Between '==' and 'is' (Equality vs Identity)

Комментарии
Автор

Hello
I'm having trouble with the following formula:
=IF(SEARCH("green", B2), "Green", IF(SEARCH("Red", B2), "Red", ""))
From the following sample
Product Colour
Red Apple #VALUE!
Green Apple Green

The formula finds the first IF/Search properly but the second nested IF/search I get a #VALUE error where searching for "red". I can't seem to figure out my mistake. Can you send me in the right direction?

Thanks a bunch.

lillianasanchez