if and or search

[VegasL]

Hello,

I'm trying to compare, row A on tab A, to row a and d on 2nd tab, using =(if(and (or(search function, and if match found, then display result in Column D, on first tab, if no match display "-"

The formula I tried below didn't work...any help would be appreciated

=if(and(or(search(A2,'job status'!$A$3:$D$7,1,1)),'job status'!B3,"-")))


Basically, comparing row A on first tab, to columns a and d on second tab (meaning if whatever is on first tab, matches either or those words on second tab, to display result (column b of 2nd tab on tab A), else "-".

I've attached a file to better explain.

Thanks In Advance