Search value error
Solved/Closed
Stu
-
Aug 11, 2016 at 04:50 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 12, 2016 at 10:26 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 12, 2016 at 10:26 AM
Related:
- This error value refers to a cell that contains a value or blanks
- Network error occurred - Guide
- If cell contains date then return value - Excel Forum
- Cmos checksum error - Guide
- If cell A1 has text then cell B2 has today's Date ✓ - Excel Forum
- Root directory is full or error in pasting - Android Forum
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 11, 2016 at 07:10 AM
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
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Aug 12, 2016 at 10:26 AM
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