Hi all,
I'm struggling a bit with a formula and i am sure you genius's will be able to help me
.
What i am trying to do is a forulma that it 2 critera match from 2 different tables then a YES will show and if not a NO will show.
So for instance, If CELL B1 has the word BMW in it and also has one of the words that are in the TABLE named BMW, so for this instance 3 Series then i want the formula Cell to state YES, if not then the cell needs to state NO.
What do you think, is this simple and i am missing something obvious?
I'm struggling a bit with a formula and i am sure you genius's will be able to help me

What i am trying to do is a forulma that it 2 critera match from 2 different tables then a YES will show and if not a NO will show.
So for instance, If CELL B1 has the word BMW in it and also has one of the words that are in the TABLE named BMW, so for this instance 3 Series then i want the formula Cell to state YES, if not then the cell needs to state NO.
What do you think, is this simple and i am missing something obvious?
Last edited: