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

kind regards