Newbie needs more help...

[JayZ]

Thanks for the help upfront.

Say I want to take a list of numbers and whenever a cell has that number it puts an x in the cell next to it so I know it was contained in my list of numbers.

So, I've tried to use the following, but it doesn't work:

=IF(A3={1,2,13,14,35,36,23,24,3,4,15,16},"X","")

I know I could write:

=IF(A3=1,"X",IF(A3=2,"X", etc ....

But there has to be a better way. Any suggestions are greatly appreciated.

Thanks again,

 

[jeffreybrown]

It looks like you are just missing the OR...

=IF(OR(A3={1,2,13,14,35,36,23,24,3,4,15,16}),"X","")

 

[JayZ]

Jeff, thanks so much for the quick reply. Really helped.

 

[jeffreybrown]

Hi JayZ...glad it worked for you

 

[T. Valko]

Thanks for the help upfront.

Say I want to take a list of numbers and whenever a cell has that number it puts an x in the cell next to it so I know it was contained in my list of numbers.

So, I've tried to use the following, but it doesn't work:

=IF(A3={1,2,13,14,35,36,23,24,3,4,15,16},"X","")

I know I could write:

=IF(A3=1,"X",IF(A3=2,"X", etc ....

But there has to be a better way. Any suggestions are greatly appreciated.

Thanks again,

Here's another one...

=IF(COUNT(MATCH(A3,{1,2,3,4,13,14,15,16,23,24,35,36},0)),"X","")

That's slightly more efficient than the IF(OR(... version.

If you create a defined name:

• Name: Array
• Refers to: ={1,2,3,4,13,14,15,16,23,24,35,36}

Then:

=IF(COUNT(MATCH(A3,Array,0)),"X","")