another multiple condition formula question

[knoxruss]

Hello -

New user here - thanks for any help in advance.

I need a formula that will check the values in several cells in a row and return the number in the last cell on that row if the conditons are met. The difficulty is that each of these cells needs to match one of a number of values.

Please let me know if that is unclear.

Thanks-

knoxruss

[darkyam]

It is a bit unclear. I think I get what you're doing, but an example workbook with dummy data would go miles toward helping us solve this for you.

[knoxruss]

Sorry -

See attached example. I would need a formula in H2 that would return the weight only if the conditions were met. The conditions could be city=Memphis, color=grn, blk, or red, size=L or M. If the conditions were met, I would want the weight displayed in H2. If not, either zero or no value.

Thanks-

knoxruss

[darkyam]

=IF(AND(A2="Memphis",OR(E2={"L","M"}),OR(C2={"grn","blk","red"})),F2,"")

[knoxruss]

Is that fomula designed to display the weight if all the conditions are met, or only one?

I need all of the conditions to be met.

Thanks for your help.

knoxruss

[darkyam]

Perhaps you should try it before you ask...

but, yes, it meets all of the conditions. That's what the AND does.

[knoxruss]

Thanks again for your help.

FYI - I did try it, but didn't get the result I had anticipated.

I think I may have a formatting issue. I'm guessing the multiple values have to be text with quotes? I tried using a cell reference and it didn't work.

For example, OR(E2={G1, G3}) with the L and M in G1 and G3 intead of OR(E2={"L","M"})

knoxruss

[darkyam]

You'd have to do OR(E2=G1,E2=G3)

[knoxruss]

That worked.

Appreciate it!