Help with Formula- Match Formula

[chris.kalna]

Hello everyone out there-

I am having trouble developing a tool for use for my employees at work. I need to make a formula that performs the following action so I can merge a summary page with a mail merge to assign workloads out daily:

What I need it to do is:
If L2 = 101,103,105,107,109,111,113,2,4,6,8,10,12 then I2=G2
If L2 = 102,104,106,108,110, 112,114,3,5,7,9,11,13 then I2=H2

[Tony Valko]

Not real clear.

If L2 = 101,103,105,107,109,111,113,2,4,6,8,10,12

Does that mean if L2 contains the EXACT string in its entirety:

101,103,105,107,109,111,113,2,4,6,8,10,12

Or, does it mean if L2 contains ANY of these numbers:

101 or 103 or 105 or 107 or 109 or 111 or etc., etc.

[Ace_XL]

Try in I2

Please Login or Register  to view this content.

or maybe you want..

Please Login or Register  to view this content.

[chris.kalna]

Sorry, it is not the whole string, it is the individual numbers between the comas sepoerating.

[Tony Valko]

Try this...

Enter the numbers in a range of cells:

A2:A14 = 101,103,105,107,109,111,113,2,4,6,8,10,12

B2:B14 = 102,104,106,108,110, 112,114,3,5,7,9,11,13

Then, this formula entered in I2:

=IF(COUNTIF(A2:A14,L2),G2,IF(COUNTIF(B2:B14,L2),H2,""))

[martindwilson]

or maybe
=IF(OR(L2={101,103,105,107,109,111,113,2,4,6,8,10,12}),G2,H2)