Search value error
Solved/Closed
Stu
-
11 Aug 2016 à 04:50
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 12 Aug 2016 à 10:26
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 12 Aug 2016 à 10:26
Related:
- This error value refers to a cell that contains a value or blanks
- Error network error occurred - Guide
- Cmos checksum error - Guide
- Technical support ps3 error code - Guide
- Error 491 play store - Guide
- How to delete a cell in word - Guide
2 responses
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
11 Aug 2016 à 07:10
11 Aug 2016 à 07:10
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
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
12 Aug 2016 à 10:26
12 Aug 2016 à 10:26
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
12 Aug 2016 à 05:02
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