Hi All,
If this was previously answered, please direct me to that link so I dont have to have you repeat yourselves haha. I honestly dont know what keywords to be searching for. Otherwise, if you can help it would be really appreciated.
My company write a bunch of orders (A) which have one or more models (B) sold on each order. Some vendors offer rebates if we sell certain models on the same order.
In this case, if my order has at least one of the qualifying models in EACH of columns D, E, F, and G, my company would qualify for a rebate.
So for example, order number 9001 (A2-A6) would qualify for a rebate because in B2-B6, those models are found in each of D, E, F, and G.
Order 9002 would not qualify because only one model (B7) is found in D-G
Order 9003 also would not qualify because only 3/4 of the models are found in D-G. B11 is not found in "G"
Is there a IF statement or something like that which I can enter into C2 and copy down that will tell me if each order qualify's?
I dont know if this makes a difference, but the models are not two digit numbers. They contain letters and numbers and can be up to digits.
Thanks all! And Happy Holidays!
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]ORDER[/TD]
[TD]MODEL[/TD]
[TD][/TD]
[TD]QUALIFYING MODEL 1[/TD]
[TD]QUALIFYING MODEL 2[/TD]
[TD]QUALIFYING MODEL 3[/TD]
[TD]QUALIFYING MODEL 4[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]9001[/TD]
[TD]1A[/TD]
[TD][/TD]
[TD]1A[/TD]
[TD]2A[/TD]
[TD]3A[/TD]
[TD]4A[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]9001[/TD]
[TD]2B[/TD]
[TD][/TD]
[TD]1B[/TD]
[TD]2B[/TD]
[TD]3B[/TD]
[TD]4B[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]9001[/TD]
[TD]3C[/TD]
[TD][/TD]
[TD]1C[/TD]
[TD][/TD]
[TD]3C[/TD]
[TD]4C[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]9001[/TD]
[TD]4D[/TD]
[TD][/TD]
[TD]1E[/TD]
[TD][/TD]
[TD]3D[/TD]
[TD]4D[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]9002[/TD]
[TD]1A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]4E[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]9003[/TD]
[TD]1E[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]4F[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]9003[/TD]
[TD]2A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]9003[/TD]
[TD]3A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]9003[/TD]
[TD]4Z[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
If this was previously answered, please direct me to that link so I dont have to have you repeat yourselves haha. I honestly dont know what keywords to be searching for. Otherwise, if you can help it would be really appreciated.
My company write a bunch of orders (A) which have one or more models (B) sold on each order. Some vendors offer rebates if we sell certain models on the same order.
In this case, if my order has at least one of the qualifying models in EACH of columns D, E, F, and G, my company would qualify for a rebate.
So for example, order number 9001 (A2-A6) would qualify for a rebate because in B2-B6, those models are found in each of D, E, F, and G.
Order 9002 would not qualify because only one model (B7) is found in D-G
Order 9003 also would not qualify because only 3/4 of the models are found in D-G. B11 is not found in "G"
Is there a IF statement or something like that which I can enter into C2 and copy down that will tell me if each order qualify's?
I dont know if this makes a difference, but the models are not two digit numbers. They contain letters and numbers and can be up to digits.
Thanks all! And Happy Holidays!
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]ORDER[/TD]
[TD]MODEL[/TD]
[TD][/TD]
[TD]QUALIFYING MODEL 1[/TD]
[TD]QUALIFYING MODEL 2[/TD]
[TD]QUALIFYING MODEL 3[/TD]
[TD]QUALIFYING MODEL 4[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]9001[/TD]
[TD]1A[/TD]
[TD][/TD]
[TD]1A[/TD]
[TD]2A[/TD]
[TD]3A[/TD]
[TD]4A[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]9001[/TD]
[TD]2B[/TD]
[TD][/TD]
[TD]1B[/TD]
[TD]2B[/TD]
[TD]3B[/TD]
[TD]4B[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]9001[/TD]
[TD]3C[/TD]
[TD][/TD]
[TD]1C[/TD]
[TD][/TD]
[TD]3C[/TD]
[TD]4C[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]9001[/TD]
[TD]4D[/TD]
[TD][/TD]
[TD]1E[/TD]
[TD][/TD]
[TD]3D[/TD]
[TD]4D[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]9002[/TD]
[TD]1A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]4E[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]9003[/TD]
[TD]1E[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]4F[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]9003[/TD]
[TD]2A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]9003[/TD]
[TD]3A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]9003[/TD]
[TD]4Z[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]