Searching a cell for the existence of a number

[scottlloyd33]

I know I've seen this but cannot find it in the archives. I've got 2 columns of Address info -- either in column L or M. What I'm trying to do is search Column L for a zero => nine. If I find it -- then address is Column L -- otherwise it has to be Column M. I'm trying:

=IF(OR(FIND({"1","2","3","4","5","6","7","8","9","0"},L2))>0,"Column L","Column M")

but to no avail. I know I've got parentheses out of whack or something. Thanks in advance...

 

[NBVC]

You need to take the quotes out from around each number and you need to qualify if the Find() result is a number since FIND() finds a position.

Try:

=IF(OR(ISNUMBER(FIND({1,2,3,4,5,6,7,8,9,0},L2))),"Column L","Column M")

 

[scottlloyd33]

A straight cut-and-paste worked like a champ. Thanks for the time-saving hint...