Search value error
Solved/Closed
Stu
-
Aug 11, 2016 at 04:50 AM
Mazzaropi
Mazzaropi
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Related:
- This error value refers to a cell that contains a value or blanks
- Error searching for networks - Guide
- Error deleting search suggestions - Guide
- Messenger error unable to complete request ✓ - Forum - Facebook Messenger
- Instagram video selfie verification error - Forum - Instagram
- Outlook 401 error ✓ - Forum - Hotmail/Outlook.com
2 replies
Mazzaropi
Aug 11, 2016 at 07:10 AM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Aug 11, 2016 at 07:10 AM
stu, Good morning.
If search_text does not appear in within_text, SEARCH returns the #VALUE! error value.
Try to use it:
=IF(IFERROR(SEARCH("BP",Sheet1!B4),FALSE),Sheet1!B3,"")
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
If search_text does not appear in within_text, SEARCH returns the #VALUE! error value.
Try to use it:
=IF(IFERROR(SEARCH("BP",Sheet1!B4),FALSE),Sheet1!B3,"")
Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Mazzaropi
Aug 12, 2016 at 10:26 AM
- Posts
- 1963
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- April 25, 2022
Aug 12, 2016 at 10:26 AM
Stuart, Good morning.
Thanks for the feedback.
Have a nice weekend.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Thanks for the feedback.
Have a nice weekend.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Aug 12, 2016 at 05:02 AM
Thank you, that has worked perfectly, and in the process I think i can use that to resolve a couple of other formula i had been thiking about but not tried out yet.
Thanks again,
kind regards
Stuart