Comparing Range of Cells to another Range of Cells, NO MATH

Hi
In the list of stuff you have you could put a lookup column (This could be anywhere) then you an ISERROR on the offset cells for example

Formula:

Please Login or Register  to view this content.

Then using this use a look up for TRUE

Formula:

Please Login or Register  to view this content.

Let me know if you'd like any more help. It's obviously not the prettiest way of doing it but it's the most straight forward one I can think of.

Cheers

Hi,

Thank you for your reply. I tried out the method that you said and it did not work for me. I don't know how to better explain what I want to do but here is an attempt:

---

Sugar Flour Butter Salt eggs can I bake?
Items I have: 2 cups 1 cup 5 tbsp 1 tspn 6
To bake Item 1: 2 cups 1 cup 3 tbsp .5 tspn 2 YES
To bake Item 2: 3 cups 3 cups 4 tbsp 1 tspn 6 NO

---

Does that make better sense? my problem is finding a correct formula that compares the ranges from the entire cells with out adding them up and just tells me if the cell in the items I have is equal to or greater than the corresponding to bake cell, all summarized into one. Like there are 5 conditions to actually be able to bake here.

I ended up figuring it out. I just ended up using the IF(AND(f3<=g3, remaining comparisons,....), "Bake", "NO"). It ended up being really long but it worked.

See the thing is I dont want to bake all the items. I just want to selectively see if I can bake one over another.

Ok, so what I'm trying to do is basically make an easy baking chart for my daughter. I want to have a list of all the things I could bake and their ingredients with an area that she can input what she has and see what item she can bake in another column

Choices:|Sugar| Flour| Butter |Salt |eggs |can I bake? |
Items I have:| 2 cups |1 cup |5 tbsp| 1 tspn |6|
To bake Item 1:| 2 cups | 1 cup |3 tbsp | .5 tspn |2 |YES |
To bake Item 2: | 3 cups | 3 cups |4 tbsp | 1 tspn |6 |NO |

I don't want to add up all the choices together and see if I can make it all; I just want to see what item I can make individually. Also, I tried out your equation and while to seemed to have worked for the ones that I could not bake, it did not give me the correct value for a trial that was able to have been baked.

Erm...How would I share that since its a file on my computer, not posted anywhere else? I included basic examples in my previous posts to the best of my ability with the given tools.

Oh ok thank you!