Excel 2007 : Find a numerical value

[slb08h]

I need to find a way to see if a cell contains any of the numbers 1-5, however, they wouldn't be by themselves. The cell would either contain initials, such as "SB" or an L and a number 1-5, such as "L4". I want the column to return an X if the cell contains either
"L1,L2,L3,L4,or L5"

[Fotis1991]

Do you mean?

=IF(OR(A1="L1",A1="L2",A1="L3",A1="L4",A1="L5"),"X","")

[tigeravatar]

slb08h,

Alternate take on Fotis' formula:

Please Login or Register  to view this content.

If it's not guaranteed to be "L#", then you should be able to use this:

Please Login or Register  to view this content.

[Pepe Le Mokko]

Palin and simple

Please Login or Register  to view this content.

would also do