Related:
- Excel search value error
- This error value refers to a cell that contains a value or blanks - Best answers
- Excel - IF is error with 2 cells match - How-To - Excel
- Excel - Search & Display query - How-To - Excel
- Excel - Search for duplicate in adjacent columns - How-To - Excel
- Vba excel search - How-To - Excel
- Excel search for similar text - How-To - Excel
2 replies
Mazzaropi
- Posts
- 1947
- Registration date
- Monday August 16, 2010
- Status
- Contributor
- Last seen
- November 11, 2021
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
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