RedDodger78
New Member
- Joined
- Feb 26, 2019
- Messages
- 3
Hi,
I am hoping that there is a way to link a vlookup formula with a isnumber(search formula.
I have a working ISNUMBER(SEARCH formula, but what I would like to do is to add in a VLOOKUP so that I am searching within the right cell for the text string. To furhter complicate what I am trying to do, i am also using an IFERROR so that I can search across multple sheets to return an answer:
=IFERROR(ISNUMBER(SEARCH(Table10[[#Headers],[XXX]],Sheet1[@[Work Description]])),IFERROR(ISNUMBER(SEARCH(Table10[[#Headers],[XXX]],Sheet2[@[Work Description]])),IFERROR(ISNUMBER(SEARCH(Table10[[#Headers],[XXX]],Sheet3[Work Description])),IFERROR(ISNUMBER(SEARCH(Table10[[#Headers],[XXX]],Sheet4[@[Work Description]])),IFERROR(ISNUMBER(SEARCH(Table10[[#Headers],[XXX]],Sheet5[[#Headers],[Work Description]])),IFERROR(ISNUMBER(SEARCH(Table10[[#Headers],[XXX]],Sheet6[[#Headers],[Work Description]])),IFERROR(ISNUMBER(SEARCH(Table10[[#Headers],[XXX]],Sheet7[[#Headers],[Work Description]])),IFERROR(ISNUMBER(SEARCH(Table10[[#Headers],[XXX]],Sheet8[DESCRIPTION])),""))))))))
As I say, this is working at returning the desired True / False statement, but what I really need to do is incorporate a VLOOKUP so that I am searching within the right cell within all of the above sheets!
Is this possible at all, as i seem to be unable to put any combination that works.
Any help greatly received.
Geoff
I am hoping that there is a way to link a vlookup formula with a isnumber(search formula.
I have a working ISNUMBER(SEARCH formula, but what I would like to do is to add in a VLOOKUP so that I am searching within the right cell for the text string. To furhter complicate what I am trying to do, i am also using an IFERROR so that I can search across multple sheets to return an answer:
=IFERROR(ISNUMBER(SEARCH(Table10[[#Headers],[XXX]],Sheet1[@[Work Description]])),IFERROR(ISNUMBER(SEARCH(Table10[[#Headers],[XXX]],Sheet2[@[Work Description]])),IFERROR(ISNUMBER(SEARCH(Table10[[#Headers],[XXX]],Sheet3[Work Description])),IFERROR(ISNUMBER(SEARCH(Table10[[#Headers],[XXX]],Sheet4[@[Work Description]])),IFERROR(ISNUMBER(SEARCH(Table10[[#Headers],[XXX]],Sheet5[[#Headers],[Work Description]])),IFERROR(ISNUMBER(SEARCH(Table10[[#Headers],[XXX]],Sheet6[[#Headers],[Work Description]])),IFERROR(ISNUMBER(SEARCH(Table10[[#Headers],[XXX]],Sheet7[[#Headers],[Work Description]])),IFERROR(ISNUMBER(SEARCH(Table10[[#Headers],[XXX]],Sheet8[DESCRIPTION])),""))))))))
As I say, this is working at returning the desired True / False statement, but what I really need to do is incorporate a VLOOKUP so that I am searching within the right cell within all of the above sheets!
Is this possible at all, as i seem to be unable to put any combination that works.
Any help greatly received.
Geoff