Using SEARCH and IF function to find two columns from one source 2

[Tricke86]

Hi Guys

I hope someone can help, I'm currently doing a project at work where i need to search for data from on sheet on another search.

The trouble i am having is to search for two columns of data from one search source. I am using a SEARCH formula but i have no idea how implement the IF function i want formula to search department 1 if nothing found then search department 2 from data on search page in C5 but i have no idea if this can be done or how to do it.

here are the formulas

 -(-IFERROR(SEARCH(Search!C$5,Data!$I5),""))

this to search department 1 and

-(-IFERROR(SEARCH(Search!C$5,Data!$J5),""))

department2

but at the moment they only return a search if both the data i enter in C5 is in both columns, this not what i want.

I have made an attachment to show you what i'm working with.search data.xlsx

the data on the excel sheet is fake

i need help asap

[oeldere]

@Tricke86

This i a duplicated post which is not allowed in this forum.

Please, stay with your other question.

[Fotis1991]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.