Confused

[twiley23]

How can i write out a formula to show: bacon and eggs is yea , but eggs and bacon is no ? Bacon is listed in A1 and.eggs in B1 then eggs is listed in A2 and bacon is listed in B2

 

[JLGWhiz]

Put this isn C1, Or the first cell of the column you want it to ruturn the value in, and drag down as far as needed.

=IF(AND(A1="Bacon",B1="Eggs"),"Yea","No")

 

[twiley23]

Perfect what if i threw in a 3rd option like pancakes so pankaces can work with bacon , but not eggs ? The keep adding and so forth

 

[JLGWhiz]

Perfect what if i threw in a 3rd option like pancakes so pankaces can work with bacon , but not eggs ? The keep adding and so forth

then somebody else will need to jump in on this thread to help you because my expertise with formulas is very basic and very limited. But there are plenty of people who monitor the forum who can do wonders with formulas, if you can clearly state what you need.

 

[Michael M]

This statement concerns me

Then keep adding and so forth

I can imagine each time we come up with a solution, you will add a new criteria...."and so forth"

I'd suggest giving us a real time example of what you will need with ALL criteria included.

If the list of criteria is substantial, a lookup list or adjacent table may be a better option.....even a VBA solution maybe.